Welcome to EMC Consulting Blogs

A similar collection of expressions at http://wiki.sqlis.com/default.aspx/SQLISWiki/ExpressionDateFunctions.html , started because I kept on wanting the same formats over and over. Feel free to add more.

Thanks again for the tips!!

The first part of the filename is dynamic in the sense I am using a For Loop to build the filename. Each iteration through the loop I'm adding a day to the filename.ie- Dal027042307.txt I'm using a filetask and am moving this file from a "Processing" folder to an "Error" folder. I then use another FileTask to rename the file from Dal027042307.txt to Dal027042307_Error_042307_16.36.39.txt

I needed a timestamp in the filename obviously so I would be able to decipher when the file errored in case I process the same file multiple times.

"Dal027"

+RIGHT("0" + (DT_STR, 2, 1252)  MONTH( GETDATE()  ), 2)

+RIGHT("0" + (DT_STR, 2, 1252)  DAY( dateadd("dd", @[User::iCounter],GETDATE())  ), 2)

+RIGHT("0" + (DT_STR, 4, 1252)  YEAR( GETDATE()  ),2)

+"_Error_"

+RIGHT("0" + (DT_STR, 2, 1252)  MONTH( GETDATE()  ), 2)

+RIGHT("0" + (DT_STR, 2, 1252)  DAY( GETDATE()  ), 2)

+RIGHT("0" + (DT_STR, 4, 1252)  YEAR( GETDATE()  ),2)

+"_"

+ RIGHT("0" + (DT_WSTR,2)DATEPART("hh", GETDATE()), 2) + "."

+ RIGHT("0" + (DT_WSTR,2)DATEPART("mi", GETDATE()), 2) + "."

+ RIGHT("0" + (DT_WSTR,2)DATEPART("ss", GETDATE()), 2)

+".txt"

Or perhaps: -

substring(replace(replace(replace((DT_STR, 100 , 1252)(DT_FILETIME) @[User::QuickPL_Creation_Time],"-",""),":","")," ",""),2,16)