SQL Server 2008 and SQL Server 2008 R2 (Enterprise editions) support bulk loading Oracle data using Integration Services packages with the Microsoft Connector for Oracle by Attunity. For SQL Server 2005 and the non-Enterprise editions of SQL Server 2008 and 2008 R2, there are alternatives for achieving optimal performance when loading Oracle data. This paper discusses these alternatives http://msdn.microsoft.com/en-us/library/hh923024.aspx.
We’ve documented this Whitepaper, which discusses the ways of implementing BULK INSERT functionality to Oracle in SSIS Packages.
Author : Snehadeep , SQL Developer Engineer , Microsoft