Your plan looks good. You'll need two different Connection Managers, one for your SQL Server and one for your Oracle instance. You could use OLE DB or ADO.NET to talk with SQL Server in 1. ADO.NET should work fine for Oracle but you have options there as well.
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato