Component

Overview

Informix Destination Component is SSIS Data Flow Component, which connects to Informix database and bulk loads data into Informix database tables. It is much faster than the standard loading , using OLE DB Destination. The configuration options are provided in the standard data flow destination component dialog. The component requires installation of IBM Data Server Runtime Client.

Setup

Use the options below to setup the component.

Options

IDbConnection

Select an existing ADO.NET IBM Informix .NET Data Provider 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.

Overview

DB2 Destination Component is SSIS Data Flow Component, which connects to DB2 database and bulk loads data into DB2 database tables. It is much faster than the standard loading , using OLE DB Destination. The configuration options are provided in the standard data flow destination component dialog. The component requires installation of IBM Data Server Runtime Client.

Setup

Use the options below to setup the component.

Options

IDbConnection

Select an existing ADO.NET IBM DB2 .NET Data Provider 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.

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.

Overview

Data Flow Source Component is SSIS Data Flow Component for consuming data in data flow from Data Flow Destination component. The configuration options are provided in the standard data flow source component dialog.

Setup

Use the options below to connect to Data Flow Destination component.

Options

PackageConnection

Specify package connection.

DataFlowDestination

Type the data flow destination, or click the browse button (…) and locate it.

Overview

Data Flow Destination Component is SSIS Data Flow Component for exposing data from a data flow to Data Flow Source component. It is similar in concept to the standard Microsoft DataReader Destination Component and it is used as a source in Data Flow Source component. The configuration options are provided in the standard data flow destination component dialog.

Setup

Use the options below to setup the component.

Options

SignalEnd (1.2 SR-2)

Variable containing ManualResetEvent object, signaling a waiting thread processing is complete. Download sample SSIS package or check following script function how to handle this variable:

    ' Returns signal end variable. If not initialized yet, initialize to ManualResetEvent.
    Private Function GetEventFinished_() As EventWaitHandle
        Dim result As EventWaitHandle
        Dim vars As Variables

        Try
            Call Dts.VariableDispenser.LockOneForWrite(SignalEnd, vars)
            If vars(SignalEnd).DataType = TypeCode.Object Then
                result = TryCast(vars(SignalEnd).Value, EventWaitHandle)
                If result Is Nothing Then
                    ' Signal variable is not yet initialized.
                    result = New ManualResetEvent(False)
                    vars(SignalEnd).Value = result
                End If
            Else
                Throw New ApplicationException("Invalid variable type")
            End If
        Finally
            If Not vars Is Nothing Then
                Call vars.Unlock()
            End If
        End Try

        GetEventFinished_ = result
    End Function    ' GetEventFinished_