fatal message in job log, yet job finishes with (warnings).

Rob4732 · Post by **Rob4732** » Fri Oct 15, 2010 11:56 am

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

ray.wurlod · Post by **ray.wurlod** » Fri Oct 15, 2010 3:47 pm

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.

Rob4732 · Post by **Rob4732** » Mon Oct 18, 2010 11:29 am

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