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

  • February 26, 2008 at 7:45 am

    #781990

    The easier and preferred method is to simply create a variable for the path and use get date functions. Click the connection manager for the output text file --> View the properites --> expand "Expressions" and modifiy the connection string as follows:

    Note: @[User::SharePath] is a variable that holds the path.

    @[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"


    My blog: http://jahaines.blogspot.com