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 |
|
PatDeV
Posting Yak Master
197 Posts |
 Posted - 2005-11-09 : 16:38:26
|
| Hi all,I have the dts that runs the fine but is does not over write the excel fiel instead it appends. How can i make to overwrite the yesterday data!!thanks |
|
|
rob3rto
Starting Member
8 Posts |
Posted - 2005-11-09 : 17:07:23
|
| One easy solution is to create a batch file that deletes the Excel file then copies a blank copy:del C:\LOC\FILE.xlscopy C:\LOC\FILEblank.xls D:\LOC\FILE.xlsExecute the file as the first step of your DTS. |
 |
|
|
PatDeV
Posting Yak Master
197 Posts |
Posted - 2005-11-09 : 17:35:11
|
| is it possible that i can make copy of that file as name of filename+thedate(such as filename1182005.xls) before deleting it?Thanks |
|
|
|
rob3rto
Starting Member
8 Posts |
|
|
|
|
|
from text to excel