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 27, 2008 at 2:01 am

    #782384

    Click on your Flatfile-Connection. In the Property Window you can see 'Expressions'. Click on the ellipsis (...) and select the property 'Connection string'. There you can create your filename with the something like "c:\\yourfile" + Replace(Replace((DT_WSTR,15)(DT_DBDATE)GETDATE() + (DT_WSTR, 15)(DT_DBTIME)GETDATE(),":",""),"-","") + ".csv"