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 |
|
krajdba
Starting Member
43 Posts |
 Posted - 2007-04-23 : 13:50:10
|
| Hi Gurus,I have a job which generate a output textfile.How to suffixtimestamp to the textfile name.For example:If the textfile name is PASStestReport.txt to thisI would like to suffix timestamp and have a filename asPASSTestReport_MMDDYYHHMM.txt. Urgent Please.Thanks & RegardsRaj. |
|
|
dinakar
Master Smack Fu Yak Hacker
2507 Posts |
Posted - 2007-04-23 : 13:51:55
|
| you can do it from the job itself. concatenate the timestamp from the script that creates the text file. Otherwise, you can write a little VBScript to rename the file.************************Life is short. Enjoy it.************************http://weblogs.sqlteam.com/dinakar/ |
 |
|
|
|
|
|
Timestamp suffix to a textfile