March 7, 2013 at 5:40 am
Hello i have a excel doc with the following data in in a column 31-JAN-13 15.04.51.590000000
how do i convert this in SSIS into a datetime column?
I got this error message
The conversion returned status value 2 and status text "The value could not be converted because of a potential loss of data.". "
March 11, 2013 at 2:49 pm
A solution I have used in the past is adding in two Derived columns one right after the other. In the first pick apart your date in to a Year derived column and subsequently a Month and Day also using the date/time functions. Then in the next Derived Column reassemble the parts you need. This will probably work with the time also but with what I saw in your post it may be a little more difficult.
March 11, 2013 at 2:52 pm
I have done similar with the derived columns. That is what I would recommend.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply