1
votes

As far I know, SSIS packages can be deployed using any of the following deployment strategies:

  1. File system
  2. MSDB
  3. SSIS Catalog

In file system , we will make use of server agent to trigger the .dtsx file.

For MSDB and Catalog deployment , we have different steps to follow.

Now the problem ,

I am looking for a way to export the packages and its dependencies from MSDB / SSIS catalog .

These can be doable through GUI (Sql Server Management Studio - Integration Service ).

How to programmatically export the SSIS packages from SSIS Catalog / MSDB using commands / powershell ?

Anyone have idea on this?

1

1 Answers

1
votes

Ashif, Jamie Thomson's blog for dumping SSIS packages from a server to files should help.

enter link description here