Home Forums SQL Server 2005 SQL Server 2005 Integration Services to rename a file by attaching datestamp at the end of filename using SSIS File task RE: to rename a file by attaching datestamp at the end of filename using SSIS File task
Tommy Bollhofer
SSChampion
Points: 14940
More actions
February 27, 2008 at 11:21 am
#782746
Try -
@[User::Path] + "\\" + "Holdings_" + (DT_STR,4,1252) DatePart("yyyy",getdate()) + Right("0" + (DT_STR,4,1252) DatePart("m",getdate()),2) + Right("0" + (DT_STR,4,1252) DatePart("d",getdate()),2) + ".csv"
Tommy