Since it includes quite a few steps, the following links (with visuals) would help you
In my previous Job I was successfully using the IBM DB2 ODBC Driver.
Then once the ODBC connection is configured, you can use an OLE DB Driver for ODBC and use that for connecting the DB2. (Don't forget to define a system wide DSN.
Other option is to define a Linked server again as OLE DB for ODBC and the use OPENQUERY selects in SSIS.
I have used both methods on several systems with success.
answered Feb 14, 2012 at 07:04 PM