Hi All,
I am using DTS to import a flat text file into a SQL
Server 2000 table and the fields that I am having an
issue with are DateTime fields.
In the text file my time is broken out "12:00 PM" when I
import it into SQL Server Table that is defined as
smalldatetime or datetime - it drops the 12 from the time
making it 00:00 PM. I tried capital "HH" and lower
case "hh" in the transformation that is defined for it
and one works(incorrectly) and the other won't even run.
Can someone help me out? I can import that field in as
varchar but then I can't to time functions against it.
If someone can help me out that would be totally awesome.
Thanks
Gina
gscott (AT) mchenry (DOT) edu