This reply is a bit late, but still worth knowing. If you can use third-party solutions, check the commercial CozyRoc Excel components. These are the relevant components:
* Excel Source component - for reading data from Excel worksheet.
* Excel Destination component - for writing data in Excel worksheet.
* Excel Task - for manipulating Excel workbooks.
* Excel Connection - used by the components above and also for implementing custom scripts based on it.
The enhanced adapters provides ability to add/remove Excel encryption password.
---
SSIS Tasks Components Scripts Services | http://www.cozyroc.com/