We have recently decided to migrate from SQL Server 200 to 2005. We have
many processes built in 2000 DTS packages that pull data in from DB2 via an
ODBC connection. Of course, the Migration tool is of no use in moving these
packages to SSIS. How to I pull in my DW (DB2) data into SQL Server 2005
using SSIS. I can create the ODBC connection in SSIS and get it to test
successfully (but it doesn't appear to save the password). I already have
the DB2 client installed and ODBC connections set up but I just can't seem to
figure out how to pull the data in. Doing searches online, I was trying to
use the DataReader Source but I keep getting the following error "Error at
Data Flow Task [DataReader Source [52]]: Cannot acquire a managed connection
from the run-time connection manager."

What is the best way to pull in DB2 data? Surely this has to be a fairly
common scenario. Thanks.