ETL and Data Integration tools - Modern ETL software for everyone

Hi,

Am trying to insert records using a SQL2000 source and SQL2000 destination, and I get the following error. The ETL is happy if column 'comments' (mentioned in error below) is set to be ignored. I was wondering if you would have any ideas or suggestions about this error.

Would appreciate your response.
Cheers,
Mary


Record:1 Line:1 SQLBindParameter Failed for Field comments Value:Registered 18/03/2011 - De-registered 18/03/2011. XXX no longer works at the schhol- SSSS is the new contact. HY104 [Microsoft][ODBC SQL Server Driver]Invalid precision value

Hi.

Can I ask you to send us the following information

Table's creations scripts

Example of data

Mapping screeshots will be usefull as well

Mike

Hi,

Thank you for your response. This issue has been resolved (column data type needed a change).

Cheers,
Mary