Hi,
I have set up a DTS package to export data to an excel sheet. If I schedule it the data appends to the exisitng data in the sheet.
How do I overwrite the data or update the data in sheet so that I may schedule a fresh updated copy to be sent to same file?
Thanks