Need to convert date into string literal in SSIS

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » Data Warehousing » Integration Services » Need to convert date into string literal in...

Need to convert date into string literal in SSIS

Rate Topic

Display Mode

Topic Options

Author

Message

manibad

Posted Wednesday, February 27, 2013 1:55 PM

Grasshopper

Group: General Forum Members
Last Login: Friday, May 10, 2013 2:00 PM
Points: 24, Visits: 94

I need to convert date into string literal in SSIS in derived column.How is it possible.
Example:
Input-2013-01-07 00:00:00.000
Output-07012013
Please guide me in achieving this in SSIS.
Thanks in advance

Post #1424738

robert.gerald.taylor

Posted Wednesday, February 27, 2013 3:00 PM

Right there with Babe

Group: General Forum Members
Last Login: Yesterday @ 2:31 AM
Points: 733, Visits: 781

manibad (2/27/2013)

Just off the top of my head, try an expression like:

RIGHT("0" + (DT_WSTR,2)DAY(GETDATE(),2) + RIGHT("0" + (DT_WSTR,2)MONTH(GETDATE(),2) + (DT_WSTR, 4)YEAR(GETDATE())

HTH,
Rob

Post #1424778

kl25

Posted Wednesday, February 27, 2013 3:45 PM

SSC Veteran

Group: General Forum Members
Last Login: Friday, May 10, 2013 4:23 PM
Points: 237, Visits: 1,092

Here's another option:

SUBSTRING((DT_WSTR,10)(DT_DBDATE)GETDATE(),6,2) + SUBSTRING((DT_WSTR,10)(DT_DBDATE)GETDATE(),9,2) + SUBSTRING((DT_WSTR,10)(DT_DBDATE)GETDATE(),1,4)

Post #1424799

« Prev Topic | Next Topic »

Permissions