• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 652
  • Last Modified:

Overwrite current excel data usingSSIS

I have a data flow task that dumps data from Oledb source to excel destination. Iwantthe excel to overwrite the data everytime I am running that package with my new data.
2 Solutions
Jim HornMicrosoft SQL Server Developer, Architect, and AuthorCommented:
Assuming 'the data' means 'the data in the Excel doc'.

Is this an option?
*  Use a File System Task to delete the Excel doc
*  Then pump the data, which creates a new Excel doc?

I've experienced various issues with pumping data to an existing Excel doc, where it pumps starting at the row at the end of the previous dump, and using named ranges wasn't able to resolve it.
You can also keep an empty version of the workbook in another folder as a template, delete the existing one, and copy the template version in over where it was. This also allows you to have permanent/persistent stuff in the Excel - like headers, f'rinstance.

Featured Post

Veeam Disaster Recovery in Microsoft Azure

Veeam PN for Microsoft Azure is a FREE solution designed to simplify and automate the setup of a DR site in Microsoft Azure using lightweight software-defined networking. It reduces the complexity of VPN deployments and is designed for businesses of ALL sizes.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now