March 29, 2004 at 6:33 am
I am trying to transfer data from a text file to SQL using DTS but I always get this error.
Error at Destination for Row number 2321. Errors encountered so far in this task: 1. Insert error, column 15('agreement_date', DBTYPE_DBTIMESTAMP), status 6: Data overflow. Invalid character value for cast specification.
If this is a problem with wrong datatype, it should have stopped at the first row and I could just change the datatype of 'agreement_date' but it went all the way to 2321st record so now I am lost to how I should correct this error.
Thanks,
SQLTool
March 29, 2004 at 1:17 pm
It sounds like there is an invalid value in your agreement_date field. Try validating the field value as it is read. If you are using the transform data task, use an activeX script to move this text column into the database like so:
If (IsDate(DTSSource("text_file_field_name")) Then
DTSDestination("agreement_date") = DTSSource("text_file_field_name")
Else
DTSDestination("agreement_date") = some default value
Endif
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply