Convert datetime in SSIS

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2005 » SQL Server 2005 Integration Services » Convert datetime in SSIS

Convert datetime in SSIS

Rate Topic

Display Mode

Topic Options

Author

Message

leon.booij

Posted Thursday, March 07, 2013 5:40 AM

SSC Rookie

Group: General Forum Members
Last Login: Monday, May 13, 2013 3:06 AM
Points: 27, Visits: 221

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.". "

Post #1427912

jamesl 88576

Posted Monday, March 11, 2013 2:49 PM

Forum Newbie

Group: General Forum Members
Last Login: Monday, May 13, 2013 1:04 PM
Points: 4, Visits: 28

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.

Post #1429482

SQLRNNR

Posted Monday, March 11, 2013 2:52 PM

SSCoach

Group: General Forum Members
Last Login: Thursday, May 16, 2013 1:46 PM
Points: 18,732, Visits: 12,329

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 2008

SQL RNNR

Posting Performance Based Questions - Gail Shaw
Posting Data Etiquette - Jeff Moden
Hidden RBAR - Jeff Moden
VLFs and the Tran Log - Kimberly Tripp

Post #1429484

« Prev Topic | Next Topic »

Permissions