When using DTS to import datetime data, we find that when the source file
contains a datetime such as "2005-12-27 12:47:21AM" it converts it to
12:47PM. If I insert the above value, it gets converted correctly. I have
tried fooling with the datetime string conversion and no matter what tokens I
select, the value is 12 hours off. This only happens for AM values that have
a 12 or PM values that have a 12 hour.

TIA

FWIW, I used activex and struffed the source into a variable and then used
the year, month, day, etc. functions to concatenate a value for the
destination.

"Jeffrey K. Ericson" wrote:

"Jeffrey K. Ericson" wrote:


Sounds like your source file has format issues. Format the source correctly
i.e. 2006-01-06 00:01:01.000 and 2006-01-06 13:01:25.000
If the source file is too large and you are constantly moving it into and
out of sql, then you might have to format it later liek you propose.