I'm importing a text file into SQL Server 2008 R2 using SSIS 2008 R2. Included in the text file is a datetime column with values like "2010-09-24 18:58:29.220". However, when I import the file, the stored value has the time portion replaced with
what I assume is the default, such as "2010-09-24 00:00:00.000".
Is there an easy way to import a datetime value from a text file into a datetime column in my table? I've tried every form of date datatype in the Flat File Connection Manager, but I still keep getting the correct date portion with the incorrect time
Am I trying to do something that wasn't intended? I see Todd McDermid's page (http://toddmcdermid.blogspot.com/2008/11/converting-strings-to-dates-in-derived.html)
and am starting to wonder if perhaps I'm trying to shortcut something that I shouldn't.
View Complete Post