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.
    ssis_e1
  2. If you want to run the multiple packages from the one package then you just add multiple times the “Execute Package Task”.
    ssis_e2
  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 optionssis_e3
Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s