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 |
|
cthompson
Starting Member
11 Posts |
 Posted - 2005-07-04 : 09:54:22
|
| Hi GuysIs there away on the Text File(Destination)option within DTS to add a datestamp to the filename.For example:NewAccount.txt - needs to become NewAccount04072005The reason for this request is to prevent the loss of any text file that is created.Thanks in advance for any help on this issue.RegardsChris |
|
|
mwjdavidson
Aged Yak Warrior
735 Posts |
Posted - 2005-07-04 : 10:00:11
|
| Use an ActiveX Script task to set the DataSource property of the text file connection (use VBScript date functions to return the date string). |
 |
|
|
|
|
|
Text File Destination option within DTS(Completed)