Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

Execute other SSIS packages in an existing SSIS package

Tags:

ssis

I have an existing SSIS package (load1) that loads data from one server(srv1) to my server(srv2). Before I can run load1 there are 2 other loads that needs to run on srv1 before load1 can run and fetch the said data that load2 and load3 loaded into their tables. Is there a way I can integrate a task in load1 to execute loads 2 and 3 on srv1? What type of SSIS tool should I be using for this?

enter image description here

enter image description here

The Full_load are the ones that needs to be executed in load1 on srv2. As you can see from the pics, its two different servers and only srv2 is being used.

like image 578
Louis Avatar asked Apr 26 '13 04:04

Louis


1 Answers

If you want to execute a package (load2,load3) inside a package (load1) you can use execute Package task

Refere this link

like image 107
Maximus Avatar answered Sep 30 '22 20:09

Maximus