The Oracle Bulk Load Component is used for bulk inserting records into Oracle, and is a variation of the
SQL Component. You must use this with an ADO.Net connection using the Oracle ODP.Net driver, available for download from
http://www.oracle.com/technetwork/topics/dotnet/index-085163.html.
Note that you may require a 64-bit version of this driver to run on a 64-bit
machine.
Configuring this component is very straightforward. After dragging it onto the design surface and linking the predecessor component, simply double-click to
show the configuration form. The following interface is presented:
On this first page simply select or create the ODP.Net connection, and select the table or view name.
The Parameter Bindings page then allows you to link column contents, variables
or constant values to the fields in this view or table by drag and drop.
For further assistance please see the
SQL Component.