SSIS - Delete or Truncate and Excel Destination Table

[TickerTimer]

Hi

I am transferring data from an SQL table to an Excel Spreadsheet / Table.

I need to delete the previous data and refresh it with new data each time the SSIS package is run. However I need the spreadsheet and the table (page) within it to remain constant (i.e. the names need to stay the same).

The approach I keep reading about, suggests adding an Execute SQL task (DELETE TABLE 'Excel_Table_Name') to delete the current table/page and then add another Execute SQL task to create it again.

Whenever, I try this, the DELETE table approach only deletes the table/page headings - it doesn't delete the page/table.

Does any one know where I'm going wrong or an approach that works?

All help appreciated.

Thanks.

 

[TickerTimer]

For clarification I'm using 'DROP TABLE' not 'DELETE TABLE'