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.
Note: 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:
Check Constraints - Checks constraints while data is being inserted. Value=16.
Fire Triggers - Causes the server to fire the insert triggers for rows being inserted into the database. Value=32.
Keep Identity - Preserves source identity values. When not enabled, identity values are assigned by the destination. Value=1.
Keep Nulls - Preserves null values in the destination table regardless of the settings for default values. When not enabled, null values are replaced by column default values, where applicable. Value=64.
Table Lock - Assigns a table lock for the duration of the bulk copy operation. Other applications are not permitted to update the table during the copy operation. When not enabled, the default bulk locking mechanism (row or table) specified by the table lock on bulk load server option is used. Value=2.
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.
Check Constraints - Checks constraints while data is being inserted. Value=16.