You can use the data flow plus component from cosyrock.

If you only use on BIDS (and not on sql server agent) it is free. You can then do true ETL stuff with a for each loop to each table).

the only thing first is to create the table structure on SQL server or Oracle.

There is a nice small turorial here:

http://www.cozyroc.com/ssis/data-flow-task