Oracle Destination

Overview

Oracle Destination Component is SSIS Data Flow Component, which connects to Oracle database and bulk loads data into Oracle tables. It uses a direct path load approach. Using direct path load is faster than the standard loading (using the OLE DB Destination) as it formats Oracle data blocks and writes the data blocks directly to the data files. This eliminates considerable processing overhead. The configuration options are provided in the standard data flow destination component dialog. The component requires installation of Oracle 11g Client 11.1.0.6.20.

Setup

Use the options below to setup the component.

Options

IDbConnection

Select an existing ADO.NET Oracle Data Provider for .NET connection manager, or click <New connection...> to create a connection manager.

Related Topics: ADO.NET Connection Manager

DestinationTable

Specify the destination database table where the data is loaded.

DestinationPartition

Specify the destination table partition where the data is loaded. This property is not required if destination is single partition table.

BatchSize

Specify the number of rows to be sent as a batch.

Timeout

Specify the number of seconds allowed for the bulk copy operation to complete before it is aborted.