Error inserting TIME using DTS
Posted on 2003-03-02
I am reading the time from a file where the time is in the format HH.mm.ss (the time is 24 hour time eg 17.45.20) and inserting the time into a datetime field in a SQL server 2000 table. I am using DTS to take the date from the file (delimeted with |) and insert into the table.
If I right click onthe transform (under the transformations tab) and click "test" the task is executed successfully and I can see the time correctly inserted. However, if I execute the package, The task fails on the time columns with an error of:
status 6: Data overflow.
Invalid character value for cast specification.
I do not understand why this is occuring, can anyone please help.