DB2 destination

SQL Server 2005, 2008, 2008R2, 2012, 2014

SQL Server 2005, 2008, 2008R2, 2012, 2014

All Downloads ----- Join VIP ----- Questions?

Overview

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


Demonstration

Setup

Use the parameters below to set up the component.

Options

IDbConnection

Select an existing ADO.NET IBM DB2 .NET Data Provider connection manager, or click <New connection...> to create a new connection manager.

Related Topics: ADO.NET Connection Manager

DestinationTable

Specify the destination database table where the data is to be loaded.

How to modify a destination table dynamically at runtime

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

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

Samples

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

    The NumberOfRows variable controls the number of rows inserted.