| SSIS Oracle Bulk Load Connector |
 |
SSIS Oracle Bulk Load Connector has been built as a component to be available inside Business Development Studio environment. This is a data flow Destination Component that can be used in Data Flow tasks of SSIS to bulk load data into Oracle Server. The connector provides a way to transfer data to Oracle Server in a very fast and effective manner.
Built on .NET platform, it seamlessly integrates with Business Intelligence Design Studio.
Performance Results
Column Details:
|
Source (Flat File) |
Destination (Oracle) |
|
DT_DBDATE |
DATE |
|
DT_NUMERIC |
NUMERIC(10,2) |
|
DT_STR |
VARCHAR2(15) |
|
DT_TEXT |
BLOB |
|
Load Time:
|
|
Oracle Bulk Load Connector Component |
OLE DB Destination Component |
Performance Gain Oracle Bulk Load Connector |
|
1 mn rows
(File Size - 51.4 MB) |
00 hr 01 min 07 sec |
02 hrs 22 min 11 sec |
12732.83% |
|
2 mn rows
(File Size - 102 MB) |
00 hr 02 min 14 sec |
04 hrs 57 min 15 sec |
13309.70% |
|
Configuration:
| Intel Pentium 4 Dual Processor CPU 2.80 GHz, 2.79 GHz |
| 1 GB RAM |
| Microsoft Windows XP Professional SP2 |
| Oracle 9i Server |
| Oracle 9i Client |
|
Features & Benefits of SSIS Oracle Bulk Load Connector
- Support for all Oracle data types except INTERVAL YEAR TO MONTH, INTERVAL DAY TO SECOND, ROWID and UROWID
- Support for all SSIS data types
- Compatible with Oracle 8i, 9i & 10g versions
- Support for Oracle table's sub partition
- Support for error row handling
- Describes error details in form of Oracle Error Codes
- Seamlessly integrates with Visual Studio's Business Intelligence Design Studio
- Support for Large Objects in Oracle
- High performance loading mechanism. Much better performance as compared to OLE DB Destination Component
- Unicode and Non-Unicode character support
|
About Persistent
