Hey Guys I am working with SSIS and Csharp in Visual Studio and at the moment I get data from a SQL Database and put it into a excel file and then send it as attachment per mail.

But now I want to update my excel file every hour with the new data. The issue I have is that when I try to do it, excel dont update the file because it only adds the data to the file. This results in an enormous big file.

Can someone help me or has a link where I can find a solution?

Thank you very much.

CodePudding user response：

There are a number of answers to this old query on the same topic that may help you: How to overwrite Excel destination in SSIS?