How to convert datetime to string format (YYYYMMDD) in SSIS?

• karthick.alangattan

  SSC Veteran

  Points: 283

  More actions

  February 27, 2013 at 10:23 pm

  #290127

  How to convert datetime to string format (YYYYMMDD) in SSIS?

  I have done using Datepart but for the date 01 to 09 it gives the values as 1 to 9. I need values should be as 01. Anybody guide me

• Lynn Pettis

  SSC Guru

  Points: 442467

  More actions

  February 27, 2013 at 10:48 pm

  #1591870

  Not sure how to do it in SSIS but in T-SQL:

  CONVERT(VARCHAR(8),MyDateCol, 112)

  Can you convert it prior to SSIS doing its thing?

• Phil Parkin

  SSC Guru

  Points: 247159

  More actions

  February 28, 2013 at 1:13 am

  #1591893

  karthick.alangattan (2/27/2013)

  ---

  How to convert datetime to string format (YYYYMMDD) in SSIS?

  I have done using Datepart but for the date 01 to 09 it gives the values as 1 to 9. I need values should be as 01. Anybody guide me

  You can get round the issue you mentioned by doing something like this (untested):

  right("0" + Datepart(...), 2)

  ---

• kl25

  Hall of Fame

  Points: 3752

  More actions

  February 28, 2013 at 9:14 am

  #1592024

  Here's another option.

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

• Phil Parkin

  SSC Guru

  Points: 247159

  More actions

  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.

  ---