hi I have taking flatfile source name dynamically I e filename like source 2011-08-11 I m creating expression builder for taking most recent file as per filename I did like Created one variable which is having folder path C backup now inside expression builder how can i add date i tried like User DirPath source DT STR 4 1252 YEAR DATEADD dd -1 getdate - DT STR 4 1252 MONTH DATEADD dd -1 getdate - DT STR 4 1252 DAY DATEADD dd -1 getdate CSV which is wrong please give me the expression which gives me output source 2011-08-11

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

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

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"

~ Answered on 2011-08-03 06:50:31

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

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

Most Viewed Questions: