<p>Is it possible to delete rows in an excel worksheet from SSIS?</p>

From
forum
create a file system task in control flow, deleting the file.
create a sql task, excel connection type, i used my previous excel connection for this, then used a create table script as my sql statement
left my previous export object the same, then linked the flow of these in this order described.