I am running SQL SERVER 2005 and have a LINKED SERVER to ORACLE.
Using ORACLE PROVIDER FOR OLE DB.
Running a simple SSIS stored procedure which SELECTS the ORACLE data and inserts it into SQL Server table.
One million records with 4 fields is taking 2 hours to truncate and re-load the table.