Part 2: The 32-Bit/64-Bit Drivers : The SQL Server Wire Protocol Driver : Connection Option Descriptions : Bulk Options

Bulk Options
Attribute
BulkLoadOptions (BLO)
Purpose
Toggles options for the bulk load process.
Valid Values
0 | x
where:
x
is a positive integer representing the cumulative total of the Bulk Options values.
Behavior
If set to 0, none of the options for bulk load are enabled.
If set to x, the values represented by x are enabled.
The cumulative value of the options is only used in a connection string with the connection string attribute, BulkLoadOptions. On the Bulk tab of the driver Setup dialog, the individual options are enabled by selecting the appropriate check box.
The following bulk load options are available:
Example
If you wanted to enable Check Constraints (16), Fire Triggers (32), and Keep Identity (1) in a connection string, you would add the values together:
BulkLoadOptions=49
To enable these options on the Bulk tab of the driver Setup dialog, you would simply select the check box for each one.
Default
2 (Table Lock enabled)
GUI Tab
Figure 6

© 2013 Progress Software Corporation and/or its subsidiaries or affiliates.