Page 1 of 1

Warning while loading using ODBC connector

Posted: Mon May 07, 2012 1:00 am
by jerome_rajan
Hi All,

We are trying to laod data to a SQL Server DB using ODBC Connector. We have a string column that we are casting to timestamp in a user defined insert statament in the connector. While the data is getting loaded correctly, we are getting the below warning:

"unable to determine association between statement parameters and table columns. Only limited schema reconciliation will be performed"

Any assistance appreciated.

Thanks in advance

Posted: Mon May 07, 2012 6:41 am
by chulett
Not sure but an exact search for "Only limited schema reconciliation will be performed" returned 8 matches, perhaps something there will help.

Posted: Mon May 07, 2012 7:26 pm
by qt_ky
Just a guess without searching, have you tried changing the data type in the job design before it hits the ODBC stage (avoiding the cast)?