Preconditions for Using DB Data Sink Components for Bulk Loading

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 some conditions.

  • Sybase IQ version must be 15.0 or above.

  • The allow_read_client_file option must be on.

  • Interface must be ODBC.

  • Do not specify the Load Stage Path.

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.

Parent topic: Destination Components
Related tasks
Enabling Client-Side Load Support