Optimized Bulk Loading of Data into Oracle

Published Jan 15 2019 02:22 PM 56 Views
First published on MSDN on Apr 11, 2012

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

Version history
Last update:
‎Jan 15 2019 02:23 PM
Updated by: