Optimized Bulk Loading of Data into Oracle

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 https://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

Comments

• Anonymous
  April 11, 2012
  The comment has been removed

• Anonymous
  April 12, 2012
  I agree to your thoughts Mike. I would like to inform you that the BULK LOAD functionality should be implemented on both sides, the SSIS and the provider side as well. There are 3rd party providers who do not implement required interfaces to perform BULK LOAD would not be able to fast load data even if SSIS offers the ability. One of the major focuses on Denali release is working with partners, spreading the awareness and encouraging them to implement the required interfaces in their provider code and take advantage of BULK LOAD through SSIS. Currently SSIS can now Fast Load data to DB2 and Netezza and I'm hopeful that soon this would be the case with a few others too. Note: Microsoft OLE DB Provider is dead and there aren't any future plan for it either, and, of course, SSIS Enterprise editions can always take advantage of the Attunity connectors.

• Anonymous
  September 21, 2012
  This paper has been updated to apply to SQL Server 2012.  The URL is the same,msdn.microsoft.com/.../hh923024.aspx