How do I format date value as yyyy-mm-dd using SSIS expression builder?

[Originally posted by]: http://stackoverflow.com/questions/6922517/how-do-i-format-date-value-as-yyyy-mm-dd-using-ssis-expression-builder

Correct expression is

"source " + (DT_STR,4,1252)DATEPART("yyyy" , getdate()) +
RIGHT("0" + (DT_STR,4,1252)DATEPART("mm" , getdate()), 2) +
RIGHT("0" + (DT_STR,4,1252)DATEPART("dd" , getdate()), 2) +".CSV"
shareedit
Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s