There IS a way to do this in SSIS. I assume you already have a connection defined for your Excel file. Using this connection, you can clear a worksheet in an existing spreadsheet.

On the Data Control tab, drag a Data Flow Task onto the surface. Edit the task. For the Connection Type, use "EXCEL", for the Connection, use your existing Excel connection. For SQL Source Type, use "Direct input". And for the SQL Statement:

drop table `yourtable`

GO

('yourtable' is the name of the worksheet).

Have this task flow into another Data Flow Task, using the same parameters, above, except for the SQL Statement:

CREATE TABLE `yourtable`(

`column1` VarChar(50),

`column2` VarChar(15),

`column3` VarChar(25),

`column4` DateTime

)

GO

(with your columns defined).

Have this task flow into your extract Data Flow Task.

Hope this helps!