Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations wOOdy-Soft on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Auto Add Date

Status
Not open for further replies.
Smithsc

Smithsc

MIS
Apr 20, 2007
143
GB
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.
 
Sort by date Sort by votes
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 [rainbow]
-----------------------------------
Behold! As a wild ass in the desert
go forth I to do my work.
--Gurnie Hallock (Dune)
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

petart
  • Locked
  • Question
Problem Date MS SQL Server
Replies
0
Views
598
petart
petart
briangriffin
  • Locked
  • Question
Add Current Date to Insert
Replies
2
Views
244
drlex
drlex
johnb1023
  • Locked
  • Question
Date conversions between Microsoft SQL Server and Viewing in MS Access
Replies
0
Views
632
johnb1023
johnb1023
Lost500
  • Locked
  • Question
add uniqueidentifier field to existing table
Replies
1
Views
190
mutley1
mutley1
NickyJay
  • Locked
  • Question
Convert date in Varchar field to datetime field - help please!
Replies
1
Views
216
drlex
drlex

Part and Inventory Search

Sponsor

Back
Top