worked

thanks

IBM's DB2 OLEDB connector issues a Select * when using the OLEDB Destination, since I can't use the MS version for DB2 I had to use an OLEDB Command with...

bump

found the problem, the connection string was correct but the field which gives the datatype for the variable had an unprintable ascii character on it.

Since the package didn't know the...

the same table name and schema are used between the QA and Prod boxes, the name of the SQL Server DB is different, but that is stored in a XML...

yes, via package configuration

just found it...

you set it via Expressions in its DataFlow Task

it was the OLE DB that was making it slow, but DataReader Source only takes a string.

How do I use expressions here or a user variable?

but the DataReader does not accept parameters