I have a list of 7500 IDs in SQL Server and I need to get
some detailed information about these individuals from
the DB2 warehouse. I am trying to avoid having to pull
the entire tables as they are quite large and I have a
rather slow connection to the warehouse server. Ideally
I would like to join my table of 7500 IDs to the DB2
table but I do not have Microsoft Host Integration Server
and consequently no MS OLE DB provider for DB2. I do
have an IBM OLE DB provider for DB2 but when I set up the
linked server I started to see some very flaky behavior
on my SQL Server database. So, is their a way to take
the 7500 IDs and feed them to an array or Global Variable
and then pull the data I need using DTS?

Any ideas would be greatly appreciated.

Thanks.
-Scott