Home Forums Data Warehousing Integration Services Need to convert date into string literal in SSIS RE: Need to convert date into string literal in SSIS

  • February 27, 2013 at 3:00 pm

    #1591759

    manibad (2/27/2013)

    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

    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