DSXchange

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

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.

The interesting thing is that even if I define an invalid table in my odbc sql server stage, the job log captures the fatal messages, but the job doesn't abort.

We are updating our sql server odbc driver to see if that makes a difference.

thx