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