asked on

Error inserting TIME using DTS

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.

ASKER CERTIFIED SOLUTION

Guy Hengel [angelIII / a3]

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

CleanupPing

paul73:
This old question needs to be finalized -- accept an answer, split points, or get a refund. For information on your options, please click here-> http:/help/closing.jsp#1
EXPERTS:
Post your closing recommendations! No comment means you don't care.

monosodiumg

No comment has been added to this question in more than 245 days, so it is now classified as abandoned.

I will leave the following recommendation for this question in the Cleanup topic area:
Accept: angelIII http:#8055775

Any objections should be posted here in the next 4 days. After that time, the question will be closed.

monosodiumg
EE Cleanup Volunteer