Home Forums Data Warehousing Integration Services How to convert datetime to string format (YYYYMMDD) in SSIS? RE: How to convert datetime to string format (YYYYMMDD) in SSIS?

  • February 28, 2013 at 10:10 am

    #1592082

    kl25 (2/28/2013)

    Here's another option.

    REPLACE((DT_WSTR, 10)(DT_DBDATE)GETDATE(),"-","")

    Good stuff - this is the way to go.

    If you haven't even tried to resolve your issue, please don't expect the hard-working volunteers here to waste their time providing links to answers which you could easily have found yourself.