Invalid character value for cast specification

bmnaidu · Post by **bmnaidu** » Tue Jun 13, 2006 8:40 am

When am running a server job am getting this warning and records are not appened to the MS Access table.

[DataStage][SQL Client][ODBC][Microsoft][ODBC Microsoft Access Driver]Invalid character value for cast specification (null).

There are no any null values or casting am specifying.

ArndW · Post by **ArndW** » Tue Jun 13, 2006 9:41 am

Remove columns one by one until the error goes away. Then post what the column data type is and the value for the error.

DSguru2B · Post by **DSguru2B** » Tue Jun 13, 2006 10:18 am

I once got this kind of error with SQL Server. It doesnt like BigInt being passed to it. I had to change that to Integer.
ArndW is right, its the sql type of one of your columns thats creating that problem. Do as he says to find out which column it is.

bmnaidu · Post by **bmnaidu** » Wed Jun 14, 2006 3:28 am

Thank you guys