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:45 pm

    #1591780

    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)