This could be solved using the Excel Object Model in a Script Task, bit it would be quite involved to program such a thing and really wouldn't require SSIS at all since all code and data access would be nothing more than a .net script.
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato