First published on MSDN on Mar 30, 2012
In SQL Server 2005, and the non-Enterprise editions of SQL 2008/SQL 2008 R2, SSIS doesn't provide an out-of-the-box option for bulk loading Oracle data. Instead, SSIS components implement single row inserts to load data to Oracle. This can result in issues such as long load times and timeout during the ETL process.
This article on MSDN provides alternatives for achieving optimal performance when loading Oracle data, including instructions and code example for a customized script component.
http://msdn.microsoft.com/en-us/library/hh923024.aspx
Updated Mar 25, 2019
Version 2.0