I can create and populate an Excel spreadsheet thru a SSIS package.
I can append data to the sheet from a SQL view, but in the package I cannot Drop or Delete the data in the spreadsheet first.
The package is to be run daily.
How do I delete (or drop) the spreadsheet before repopulating the table. I keep getting 'Table "xxxx" does not exist' - (table or sheet)