SSIS Team Blog

Helpful information and examples on how to use SQL Server Integration Services.

Bulk Loading Data to Oracle

Bulk Loading Data to Oracle

Rate This
  • Comments 1

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.

Optimized Bulk Loading of Data into Oracle

Page 1 of 1 (1 items)
Leave a Comment
  • Please add 4 and 6 and type the answer here:
  • Post