Empty Excel Sheet from DTS

[rwttm001]

Hi

My package runs fine, exporting 4 SQL views and 1 Access 97 query into 5 tabs in a destination Excel file. However when I run at again the new data is simply appended onto the end of the existing data.

I need to make it so that every time the package runs the Excel sheet only has the contents of the data at that particular time, any help greatly appreciated.

TIA

 

[DrSql]

You should think about using CSV rather than XLS. If you really need to use XLS one way to approach is Create a template of the file and keep in a backup folder.
First step of your DTS should be delete the current file and copy the empty template.
Try the below script.
GO
exec master.dbo.xp_cmdshell 'DEL C:\EXCEL\*.XLS'
GO
exec master.dbo.xp_cmdshell 'copy C:\EXCEL\BAK\TEMPLATE.XLS C:\EXCEL\BAK\'
go


Dr. Sql
goEdeveloper@yahoo.com
Good Luck.