Warning while loading using ODBC connector

[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

[chulett]

Not sure but an exact search for "Only limited schema reconciliation will be performed" returned 8 matches, perhaps something there will help.

[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)?