My server job details :
Source data file : Text File
Target Database : MS Access
The problem is when am trying to read part of text from source file (which is of the format YYYYMMDD) and append that value to a date field to the target am getting "Invalid character value for cast specification (null)".
The way am calculating is -->
Oconv(Iconv(RawOut.DOB1,"DYMD"),"D/DMY[2,2,4]").
If I change the data type of the corresponding column in the target DB to VARCHAR then it is working fine. The problem comes only if the target field is of type DATE or TIMESTAMP.
Please help me to solve this.
Invalid casting
Moderators: chulett, rschirm, roy
Invalid casting
Thanks and Regards
NAIDU BUDDHA
NAIDU BUDDHA
-
- Participant
- Posts: 232
- Joined: Fri Sep 30, 2005 4:52 am
- Contact: