don't know what you tried but for sure you didn't look where you should.

1 - Add new variable - @package - type string

2  - Add new Execute Package task

2.1...

That is one option we cannot do at this time. Is there a way to have SSIS invoke other SSIS package dynamically?

Thanks.

Koen Verbeeck (8/7/2013)

---

I don't know how big your tables are, but you can do this easily with a lookup component.

Read ID, fieldA and fieldB from ServerB into the data flow....

Koen Verbeeck (8/7/2013)

---

Now, I need to use the list of IDs from the staging table to query a table in Server B and pull the results into the staging table...

SillyDragon (8/7/2013)

---

Script Task is one way.

another way is using variable to store the list of ID, then access server B based on the variable. So you don't have to access...

Thank you all.

I am not passing anything to the SP. I need it to return the values from the select statement inside the SP.