Hi,
I'm working on a backup procedure that will export a table to a text file.
This will happen every month, and the filename will be something like this:
tablename_sept2003.csv

I need to dynamically create this file everytime the dts package runs, and
I'm not sure how to do this within DTS (I'm sure I'd use an active X
script), but how to you put the result in a destination text file object?

Thanks for any help!
--Michael

You can find sample code for doing this at:
http://www.sqldts.com/default.aspx?200

-Sue

On Tue, 16 Sep 2003 09:39:15 -0400, "Michael Ramey"
<raterus@localhost> wrote: