Wednesday, March 21, 2012

DTS package to overwrite the existing Excel

Hello,
Is there are a way to set up a DTS package
to export data to an Excel format, overwriting or deleting the existing Excel file.
Thank you,
Ythere r a few tricks for this.
(1) add a ActiveX or SQL task before the export task to delete existing xls and copy a blank xls file in the same name
(2) export as CSV file and that can be opened with excel directly (can aslo change the extension to xls)
(3) write script to delete rows from existing excle file and then append data.

No comments:

Post a Comment