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 |
|
kusumjain
Starting Member
21 Posts |
 Posted - 2008-10-22 : 16:56:25
|
| How do I add a date extension to a file when I schedule a file to save to a drive every day.FileName 01/10/2008.xlsFileName 02/10/2008.xlsAny help is appreciated.Thanks,Kusum Jain |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-10-23 : 01:23:15
|
| Are you using ssis for saving file? if yes, you can expression builder for this. Use an expression for filename property of destination file and give something like below(DB_WSTR)[@system::packagerundate] + '.xls' |
 |
|
|
|
|
|
Add a date extension to a file name when schedule