SQL Server 2000 and DTS import Date/Time - TechRepublic
General discussion
September 17, 2003 at 12:02 PM
netadmingovernment

SQL Server 2000 and DTS import Date/Time

by netadmingovernment . Updated 22 years, 8 months ago

Hi!
I am trying to import a flat text file into a SQL Server table and the text file has a time field that when I import it into SQL Server (and the sql server table is defined as smalldatetime or datetime) it imports but changes 12:00 PM to 00:00 PM – does anyone know why this is doing this? I have tried to edit transformation to HH:mm tt and to hh:mm tt and neither of them give me the right time. If I run the import and change the SQL Server table to varchar it imports correctly but I can’t run time functions against it – so I can’t do that.
Does anyone have any ideas, I am desparate.
Thanks
Gina

This discussion is locked

All Comments