Running job to load records into sql server 2008 table. One record is bad, causing the following fatal error in job log:
ODBC_INSERT_TABLE,0: [DataDirect][ODBC SQL Server Driver]Invalid character value for cast specification
<message type is fatal>
Job doesn't abort, but finishes with warnings.
Any help appreciated.
Thx
Robert
fatal message in job log, yet job finishes with (warnings).
Moderators: chulett, rschirm, roy
fatal message in job log, yet job finishes with (warnings).
We don't see things as they are;
We see them as we are.
We see them as we are.
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
This problem is being detected by the ODBC driver - it does not send that row through to SQL Server. Use a reject link from your ODBC stage to capture that row.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.