"jleis22" wrote:

> 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