Friday, March 23, 2012

Export and Import of SSIS packages

Hello All,

Is there a way to completely export an SSIS package (the package, the configuration and the SQL Agent settings).

And a way to import it into another computer running SSIS.

If yes, then can this be done by means of a script?

regards,
Abhishek.

BOL has some topics covering that:

http://msdn2.microsoft.com/en-us/library/ms141034.aspx

http://msdn2.microsoft.com/en-us/library/ms141772.aspx

Additionally, If your are using file based packages (.dtsx); whatever method you choose that can copy the package files and configuration files (if used) will work.

No comments:

Post a Comment