Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2005-05-16 : 08:24:18
|
| Nosheen writes "Hi I have an urgent deadline on a project.I am scheduled a DTS export to a text file every 15mins. I need the export filename to change with every export. The filename format has date and time to uniquely identify the result file of each export, so that a history of export results are available. How can i change the export file name to show the time in the filename structure??help!thanksNosheen" |
|
|
mwjdavidson
Aged Yak Warrior
735 Posts |
Posted - 2005-05-16 : 10:22:05
|
| Write an ActiveX script to:1. Initialise a variable with the filename incorporating the current date and time. 2. Set the Text Connection's DataSource property accordingly.You'll doubtless have to use a combination of date and string functions in the ActiveX script to generate your desired result.Let me know if you need further pointers. |
 |
|
|
|
|
|
scheduled DTS export..