DTS customization

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?

Ansonanson.zeall@.quicken.com.au (anson) wrote in message news:<7a13e84c.0309032008.7824d3be@.posting.google.com>...
> 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

One way is to use a global variable for the file name, then you set it
and assign it to the connection in an ActiveX step, or with a dynamic
properties task. This should help you get started:

http://www.sqldts.com/default.aspx?200

Simon