troubleshooting Question

Scheduled SSIS Package - Managing the Excel Output File

Avatar of mjs082969
mjs082969 asked on
Microsoft SQL ServerMicrosoft SQL Server 2005
4 Comments1 Solution259 ViewsLast Modified:
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,

- Michael

Our community of experts have been thoroughly vetted for their expertise and industry experience.

Join our community to see this answer!
Unlock 1 Answer and 4 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 4 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros