Truncating Data When Exporting to Excel

I built a Data Transformation Services (DTS) package that exports data from a table in SQL Server 7.0 to a spreadsheet in Microsoft Excel. The package’s first run works fine, but subsequent runs just append the data to the spreadsheet instead of replacing it in the spreadsheet. How can I avoid this

Read More - Register for Free Membership