DB Bulk Load Sybase IQ

DB Bulk Load Sybase IQ uses the Load Table utility to add records to a Sybase IQ table.

Use this component to add all records from the IN-port of the component to a table in a Sybase IQ database.

StepsTo use this component

  1. Add the component to the project and connect the ports to adjacent components.

  2. Enter the Connection Parameters as described in “Entering database connection parameters”.

  3. Click Destination Table and select the table to be used from the list of available tables.

  4. Click Load Stage and select the file to be used as the temporary data file, or enter a pipe name (syntax: pipe://<name>).

    Note For performance reasons, it is recommended that you run both ETL Server and IQ database on the same machine; however, this is not required.