Loading data to Sybase

These are the properties that can be set to customize the bulk load operation when the stage is configured for Sybase databases.

Before load stored procedure

Specifies the name of the stored procedure in the database to run after connecting to the database and before loading any data to the target table.

There is no default value.

After load stored procedure

Specifies the name of the stored procedure in the database to run after loading all the data to the target table and before the job ends.

There is no default value.

Batch size

Specifies the number of rows to load before issuing a commit call. The rows are loaded in delayed mode and are committed to the target table when the stage issues commit call on the database load interface.

The default value is 0 which means that all the loaded rows are committed at once. This property corresponds to Sybase BCP -b switch.

Packet size

Specifies the size of the data packet in bytes to send to the server. The supported values are in the range from 512 to 65,535. The default value is 4,096.

Use source identity data

Specifies whether to override the automatically generated Identity column. This property is the equivalent of the Sybase BCP -E switch.

The supported values are:

Yes: Overrides the identity column with values provided in the data.; This is the default value.
No: Uses the database generated values.