While SSIS has always been able to load SQL Server at high speed it doesn't use any of the high speed Oracle APIs that are available. Well there is now a new high performance loader for Oracle and another one for Teradata. Downloads are here.