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

  • March 3, 2008 at 8:17 am

    #784439

    If you look at Adam's example, he's using a RIGHT function in conjuction w/ the leading zero to format the date.

    @[User::SharePath] +RIGHT("0" + (DT_STR,4,1252) DatePart("yyyy",getdate()),4)+Right("0" + (DT_STR,4,1252) DatePart("m",getdate()),2) +Right("0" + (DT_STR,4,1252) DatePart("d",getdate()),2) + ".txt"

    i.e.

    20080301 vs. 200831

    Tommy

    Follow @sqlscribe