Auto Add Date

[Smithsc]

I have a DTS which transfers data from a table into a CSV file and saves it in one of our network drives. Is it possible to automatically add the date to the CSV filename every time it is run so that it doesn't overwrite the previous copy.

 

[JohnDTampaBay]

You can use an ActiveX script to dynamically calculate the filename and change the DataSource property of the Destination connection, or possibly just a Dynamic Properties Task. Good luck!

--John
-----------------------------------
Behold! As a wild ass in the desert
go forth I to do my work.
--Gurnie Hallock (Dune)