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.
Invalid character value for cast specification
Moderators: chulett, rschirm, roy
Invalid character value for cast specification
Thanks and Regards
NAIDU BUDDHA
NAIDU BUDDHA
Remove columns one by one until the error goes away. Then post what the column data type is and the value for the error.
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>
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.
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.
Creativity is allowing yourself to make mistakes. Art is knowing which ones to keep.