Results 1 to 2 of 2
  1. #1
    Join Date
    Sep 2003
    Posts
    1

    Red face Unanswered: Using DTS in Microsoft SQL Server

    Dear techs,

    Hmm...I have a little problem using DTS. I made a simple DTS package where it extracts data from my database using a Stored Procedure and then exports it into a list. But everytime I export, it overwrites the file ('caused by statically entering the location of the file in Enterprise Manager) but I don't want it to do that. I want it to do something like this:

    1. After exporting the first time, I want it to label as sample20030904.csv
    2. The next time I export again, I want it to create another file and label as sample20030905.csv

    Is it possible to do something like that?

    Anson

  2. #2
    Join Date
    Oct 2001
    Location
    England
    Posts
    426
    This would be much easier (and faster) if you could just create the file using bcp or osql in a stored proc.

    To change the file name you can access the task properties in an activex script.

    See http://www.nigelrivett.net/SetDTSRunTimeValues.html for changing a connection. The filename should be similar.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •