The DB Bulk Load Sybase IQ component uses the Load Table utility to add records to a Sybase IQ table.
Use this component if you want to add all records from the IN-port of the component to a table in a Sybase IQ database.
Add the component to the project and connect the ports to adjacent components.
Enter the Connection Parameters as described in “Entering database connection parameters”.
Click Destination Table and select the table to be used from the list of available tables.
Click Load Stage and select the file to be used
as the temporary data file, or enter a pipe name (syntax: pipe://<name>
).
Using named pipes is only supported if both the ETL Server and the target IQ database are running on the Windows operating system. For performance reasons, it is recommended that you run both services on the same machine; however, this is not required.