SSIS, Data Transformation Task hang

[vicky]

Source is a datareader, destination is a OLEDB table, the connection manager
is ODBC type. It was running fine on all the 2005 servers previously, but not
the one I am woking on right now. The difference is the latest server has the
sql 2005 service pack 3 installed while others only have service pack2. The
symptom is the datareader step is standing in yellow forever. I am pretty
sure the ODBC connection is working fine, because I can see the column names
when creating the data source. No errors reported when I run the task from
Job or from BID.
Could anybody help me out? Thanks!

[eprobst]

Hi Vicky!
I had a similar problem with the native Navision ODBC Driver.
There I had to change the setting RetainSameConnection in the Properties of
the Connection Manager to get it working.
SSIS 2005: false
SSIS 2008: true
Maybe this helps.
Regards, Elke

Post by vicky
Source is a datareader, destination is a OLEDB table, the connection manager
is ODBC type. It was running fine on all the 2005 servers previously, but not
the one I am woking on right now. The difference is the latest server has the
sql 2005 service pack 3 installed while others only have service pack2. The
symptom is the datareader step is standing in yellow forever. I am pretty
sure the ODBC connection is working fine, because I can see the column names
when creating the data source. No errors reported when I run the task from
Job or from BID.
Could anybody help me out? Thanks!