CozyRoc
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.
Demonstration
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.
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 [Informix 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 Informix Destination against the standard OLEDB Destination, check this package. You have to create TEST_TABLE table with following columns:
- col1 INTEGER
- col2 DATE
- col3 FLOAT
- col4 NVARCHAR (250)
- col5 NVARCHAR (250)
- col6 DECIMAL (16)
NumberOfRows variable controls the amount of inserted rows.
