Thursday, February 16, 2012

best way to move dtsx to a new server and be able to edit the package

What is the best way to move a SSIS solution to a new server so that I can edit the solution when I have problems?

Thanks,

Copy the .dtsx files to the server using a mapped network drive, or other similar techniques suitable to your environment.|||

Okay I have done this. I have added it as a stored package.

How how do I edit this package? Can I edit it from enterprise manager or do I have to open up the development envionment. And if I go into the development environment and go to open project, what file can I open?

Thanks for the help.

|||

Packages have to be modified in BIDS. If you are storing it in SQL Server you have to export it to the file system in order to modify it. If you are storing in the file system, you can just open it directly (though to get debugging features you need to have the packages in a project).

No comments:

Post a Comment