I have a simple SSIS Package (Sql Server 2005) that exports information from a view into an Excel spreadsheet. The package will be scheduled to execute daily.
The job currently runs fine. My challenge is that I am unsure as to build the functionality necessary to allow for subsequent runs. In particular:
1) How to clear the previous execution's information from the Excel spreadsheet.
2) How to rename the Excel file so as to include the current data.
The Excel file will be generated daily and transmitted to another organization.
Thanks In Advance,