Post reply

to rename a file by attaching datestamp at the end of filename using SSIS File task

  • July 6, 2010 at 5:04 am

    #1189014

    Hello - I just created an account so that I could thank Adam and Tommy for this thread - I adapted the code to put hours minutes and seconds in too but other than that it was just what I was looking for (when I found how to edit the connection string expression in VS2008!)

    Thank you 🙂

    James

  • August 18, 2010 at 2:25 pm

    #1208777

    Adam,

    Thanks for the nice streamlined solution. Works like a charm.

  • March 29, 2013 at 1:53 pm

    #1602146

    I am trying to accomplish basically the same thing, but am having big issues with it:

    using SQL 2005 to run SSIS and export file name myfile_.csv and placing it in folder on the same server "c:\apps\SalesExport\myfile.csv

    This works great, but now I either need to rename the file on the way out or after the fact to add datetime stamp like myfile_031303291245.csv. I am lost, been working on this for several days, any help would be great, thanks

Viewing 3 posts - 46 through 47 (of 47 total)

You must be logged in to reply to this topic. Login to reply