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 |
|
YogeshDesai
Posting Yak Master
136 Posts |
 Posted - 2007-05-08 : 03:30:23
|
| Hi Guys,I have created one dts package which export data from SQL server to excel.It's working fine, I have scheduled it once in a day recurring.My Actual problem is when DTS pacakage run it overwrite the previous file.I don't want to append it. Actually I want keep old file as it is and wanna create separate file on every run of DTS.Anybody can help me to solve this......Yogesh V. Desai. | SQLDBA| |
|
|
sqldba20
Posting Yak Master
183 Posts |
Posted - 2007-05-08 : 09:54:41
|
| You can add a step to copy the file... |
 |
|
|
|
|
|
How to create new file each time