How Can SSIS overwrite Excel file
I am using an SSIS package I created via the Designer to try overwrite an existing Excel file that I
originally exported with the designer.
It does not overwrite the file but leaves the original file intact.
I have an earlier version of the book but I dont think it addresses this issue.
I need assistance in the extra steps required. I believe the steps
are tasks that Drop a table and then Create The Table but I do not know where these steps would be executed
and what table names would be used.
Any help would be appreciated.