SSIS Slow Data Transfer between Oracle and SQL Server 2016
My suggestion is don't use SSIS. I have found it to be notoriously slow on transfers from Oracle to MSSQL. I was once presented with an SSIS job that was taking in excess of 4 hours to move less than 1 million rows.  I did an Oracle 10046 trace on the process and found it was doing row-by-row, slow-by-slow processing over a cursor.  I wrote a PL/SQL procedure to do a simple INSERT INTO tablename@sqllvr VALUES (SELECT  FROM oracle_table).  It completed in less than 4 minutes, vs. the 4+ hours for the SSIS method.  It's still running daily, several years later.