I would suggest you to use sql instead of ssis...
in sql create a linked server and build the script insert into with select dynamically for all the tables.. that would be a better idea in your case...
SSIS is bit difficult in this case.. but if u find any idea to do this dynamically in ssis... i am curious to know...