Hello,

I have OLE Db data source (SQL Server 2008) with 5 rows. One of the column in claimID. Another data source is IBM DB2 Iseries database. The table in DB2 has 93 million rows. I need to get only rows from DB2 table where ClaimID matces to OLE DB datasource dataset. In fact its just inner join but in two different serves.  How do I create new dataset from these two tables in SSIS. I tried using Lookup transformation. I cannot use OLE DB as datasource for DB2. 

Can anyone guide me how to do that? Do i have to use Cache transfomation ? Is there any better way to use it so that I dont have to bring in 93 million rows.

I am using  Visual Studio 2012. 

• Edited by 1234alex 7 hours 13 minutes ago

Hi 1234alex

You need to instead use the Merge Join

Advice: to make the data retrieval fast from the DB2 side ensure you sort by the key on the server.