Post reply

Adding Date/Time stamp to filename

  • July 26, 2007 at 11:46 am

    #69038

    I need to append a file name via a DTS package.  The format needs to be DDMMYYHHMMSS.  Can anyone assist? Thank you in advance for your assistance

  • July 26, 2007 at 12:47 pm

    #722686

    Depends if you are using SQL Server 2000 DTS or SQL Server Integration Services.  In the first, you will probably need to use an ActiveX Script task, in the latter you can use the File System task.

    I would also recommend you use yyyymmddhhmmss instead.  This will allow the files to sort by date if needed.

  • July 26, 2007 at 1:21 pm

    #722696

    It is SQL 2000

     

    I would like to do this in an ActiveX Script task, but am not sure how it is done.  And unfortunately I have to use the ddmmyyhhmmss format the only give is that I can us ddmmyyyyhhmmss if I can't do it anyother way. 

  • July 27, 2007 at 1:09 pm

    #723022

    What does the script need to do?  Just change the filename of a file that already exists?

  • July 27, 2007 at 1:21 pm

    #723028

    Look at the "Date Name" scripts on this site.  I use this all the time by using an execute process task:  http://www.ericphelps.com/scripting/samples/

    Though, it could probably be used in an ActiveX task as well.

  • July 27, 2007 at 1:27 pm

    #723031

    Thank you for your help.  I got it 🙂

Viewing 6 posts - 1 through 5 (of 5 total)

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