Hello,
Just a quick note on formatting SSIS date expression to display leading zeros for single digits days and months.
With refeence to this article ... http://codingstuffs.blogspot.com/2007/03/pgp-inside-ssis-package.html
The mentioned date variable can be done in a different way..
(DT_WSTR,4)YEAR(GETDATE()) +
SUBSTRING("0" + (DT_STR, 2, 1252) DATEPART( "MM", GETDATE()) , LEN( "0" + (DT_STR, 2, 1252) DATEPART( "MM", GETDATE()) ) - 1, 2 ) +
SUBSTRING("0" + (DT_STR, 2, 1252) DATEPART( "DD", GETDATE()) , LEN( "0" + (DT_STR, 2, 1252) DATEPART( "DD", GETDATE()) ) - 1, 2 )
or even using a smaller expression
Right( "0" + (DT_WSTR, 2 ) MONTH(Getdate()),2) + "-" +
Right( "0" + (DT_WSTR, 2 ) DAY(Getdate()),2) + "-" +
(DT_WSTR,4)YEAR(GETDATE())
Hope that helps.
