I am staging data from two separate data servers onto a staging server - one server contains the order information and the second server contains shipping information for that order. I am pulling across all orders modified within the last 5 days. I then want to load all the associated shipping information for those modified orders. So there are 3 servers in this scenario - the Order server, the Shipping server and the Staging server.

I tried to do a for-each container based on the list of staged orders - but with a result set in the 1000's it is a VERY slow solution.

I can't make changes to the Order or Shipping server - but I can do whatever I need on the Staging server.

What I really want to do is create a Variable object with a list of order numbers and then in my Shipping server select statement have a a filter like this:

select [shipping fields] from [shipping\_table] where order\_nbr in [variable\_list\_of\_order\_nbrs]