Dynamic File Name not working correctly

• Karthika Raman

  SSCrazy

  Points: 2520

  More actions

  September 5, 2007 at 3:22 pm

  #176383

  I have the following code in the expression for the Connection string property.

  The problem is that the leading zeros for the month and the day are being stripped out.

  @[User::outputFileDir] + "COSDEP"+(DT_WSTR, 4) DATEPART("YYYY", GETDATE()) + (DT_WSTR, 2) DATEPART("MM", GETDATE()) + (DT_WSTR, 2) DATEPART("DD", GETDATE()) +".csv"

   

  For Example for September 5, 2007, The file name is C:\CosDep200795.csv

  How do I get the formula not to drop the leading zeros

   

  Thanks

  KR

• Karthika Raman

  SSCrazy

  Points: 2520

  More actions

  September 5, 2007 at 4:02 pm

  #731634

  Found my solution:

   

  Here is the code I replaced to get the date in the format that I wanted, in case anyone is interested:

   

  (DT_WSTR,4)YEAR(GETDATE()) + RIGHT("00" + (DT_WSTR,2)MONTH(getdate()),2) + RIGHT("00" + (DT_WSTR,2)DAY(getdate()),2) +".csv"

   

  KR