SSIS: Execute multiple SSIS packages sequentially

1. In order to run a package from the other package, you use the “Execute Package Task” from the SSIS Toolbox.
   
2. If you want to run the multiple packages from the one package then you just add multiple times the “Execute Package Task”.
   
3. Click and add the “Execute package task” from the SSIS Toolbox to your box as many times as you need
4. Double click on the “Execute package task–> select Package from the left tab–>Select the package name in the PackageNameFromProjectReference option

Advertisements