Using SSIS 2008 R2 to import text files. Two of the fields contained are datetime values in the format "2010-09-24 18:58:29.220". Ultimately both the date and time need to be extracted with precision to the second, at the very least. When
I import the text file, however, the time value seems to get truncated before the date value's being imported, for an imported result of "2010-09-24 00:00:00.000".
Is my problem with the Flat File Connection Manager? Regardless of which DataType choice I use for the properties of my datetime values--I've tried every form of date datatype--the imported column values contain the correct date but the wrong
Is there an easy way to import a text file datetime value straight into a datetime column? Is it possible, or am I trying to shortcut what should be a proper process?
View Complete Post