Post reply

DTS

  • May 24, 2011 at 8:18 am

    #389579

    Hi,

    I have a DTS that has the following:

    A connection to the local server with a transformation task to export data to a text file.

    I want that when this text file is created it get not only the name but the date too.

    like : tableCard_240511151918

    How can i do this?

    In this moment the file is always created as tableCard by SQL Server DTs

  • May 24, 2011 at 8:25 am

    #1329098

    It's a long time since I used DTS, and I don't even have it installed any more, but I think you can use something called dynamic properties to achieve what you're looking for.

    John

  • May 24, 2011 at 8:29 am

    #1329104

    You need a dynamic properties task to alter the connection, or a scripting task.

    This can help you rename the file in a script task: http://www.sqldts.com/292.aspx

    http://www.sqldts.com/252.aspx

Viewing 3 posts - 1 through 2 (of 2 total)

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