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?
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.
If you want to execute a package (load2,load3) inside a package (load1) you can use execute Package task
Refere this link
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With