You must enter the Load Stage Path for the DB Data Sink components to support IQ bulk loading. To support IQ bulk loading with client-side loading, the DB Data Sink components must meet these conditions:
Sybase IQ version must be 15.0 or above.
The value of the “allow_read_client_file” option must be set to “on”. See “Enabling client-side load support”.
Interface must be ODBC.
Load Stage Path must not be specified.
Additionally:
The Insert options should not have a SQL Insert value specified in case of the DB Data Sink Insert component.
The Update options should not contain a SQL UPDATE SET clause, and none of the NON-NULLABLE column should be omitted from the list of update columns, in case of the DB Data Sink Update component.