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!

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

ActiveX script to change .txt file name

Status
Not open for further replies.

DBAchick

Programmer
Apr 27, 2000
61
I need to write an ActiveX Script that will be executed via the DTS utility in SQL Server 2000. I create 7 files using DTS but the name of the file is not a variable so it is hard coded. I would like to run a quick script after the files are created to concatenate the date to the end of the file name. From "Labor.txt" to "Labor20020315.txt".

I am at a loss as to where to start...any help is appreciated!

DBAChick

 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top