Adding date and time to a log file path in SSIS 2005
Right click your log file connection, click on properties In the property windows click on Expressions > ConnectionString Expression Add the expression: (DT_WSTR,1000) ( "C:\Temp\" + RIGHT("0" + (DT_STR,4,1252) DATEPART("year",GETDATE()),4) +