How do I delete excel rows in SSIS?

Question

Is it possible to delete rows in an excel worksheet from SSIS?

Answer 1

From forum

1. create a file system task in control flow, deleting the file.
2. 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
3. left my previous export object the same, then linked the flow of these in this order described.