There are more than one way to skin a cat.  One solution in this case is to use ActiveX, open the Excel spreadsheet and remove all the data at the beginning of the DTS.