SQL Server: Edit an SSIS dtsx package file

I have an SSIS package I created to import data from a csv file into a database table. I copied the SSIS package file which is a dtsx file to a new server. On this server the csv file will be on the E drive instead of the D drive. So all I want to change is the drive letter. I search on the web and people are saying you have to use VStudio etc. Well a simple fix for me, use Notepad and edit the file.

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s