As far I know, SSIS packages can be deployed using any of the following deployment strategies:
- File system
- MSDB
- 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?