Adding date and time to a log file path in SSIS 2005

0 Comments

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) +