Please provide more info how you are importing 1/2 million records from ORACLE to SQL Server 2005 using linked server.

I have an ORACLE Linked Server and am using SSIS to...