SSIS cannot handle changing metadata, at least not out-of-the-box.

And SSIS has issues with the data types as well (actually it is the ACE OLE DB provider which gives the issues).

I would look into scripting with .NET as an alternative.