DB2 destination

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.

Demonstration

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.

How to modify destination table dynamically at runtime?

The destination table is available in the data flow properties list. Follow these steps to setup expression:

  • Right-click on data flow canvas and select Properties menu.
  • Scroll-down and find property named like [DB2 Destination].[DestinationTable]. This is the property containing the destination table.
  • Scroll-down and find Expressions property. Setup expression to modify the statement dynamically.

Samples

  • To test the performance of DB2 Destination against the standard OLEDB Destination, check this package. You have to create TEST_TABLE table with following columns:
    • COL1 INTEGER
    • COL2 TIMESTAMP
    • COL3 DOUBLE
    • COL4 VARCHAR2 (250)
    • COL5 VARCHAR2 (250)
    • COL6 DECIMAL (5, 2)

    NumberOfRows variable controls the amount of inserted rows.