BI - SSIS Expressions

Name a File dinamically

In connections (as a File) you can change the Output File name using expressions. 

With the following expression you can named a file according with the actual date.

“C:\\Projects\\SSISPersonalTrainer\\EmployeeCount_”+
RIGHT( “0”+(DT_WSTR, 2) Month(GETDATE() ), 2 ) +
RIGHT( “0”+(DT_WSTR, 2) Day(GETDATE() ), 2 ) +
(DT_WSTR, 4) Year(GETDATE() )+”.txt”