skip to main content
DataDirect Connect Drivers : Microsoft SQL Server Driver : Connection Properties : BulkLoadOptions
  
BulkLoadOptions
Purpose
Enables bulk load protocol options for batch inserts that the driver can take advantage of when EnableBulkLoad is set to a value of true.
Valid Values
This value is the cumulative value of all enabled options. The following list describes the value and the corresponding option that is enabled:
Value
Option Enabled
1
The KeepIdentity option preserves identity values. If unspecified, identity values are ignored in the source and are assigned by the destination.
Note: If using the bulk load feature with batch inserts, this option has no effect if enabled.
2
The TableLock option assigns a table lock for the duration of the bulk copy operation. Other applications cannot update the table until the operation completes. If unspecified, the default bulk locking mechanism specified by the database server is used.
16
The CheckConstraints option checks integrity constraints while data is being copied. If unspecified, constraints are not checked.
32
The FireTriggers option causes the database server to fire insert triggers for the rows being inserted into the database. If unspecified, triggers are not fired.
64
The KeepNulls option preserves null values in the destination table regardless of the settings for default values. If unspecified, null values are replaced by column default values where applicable.
Behavior
If set to 0, all the options are disabled.
Example
A value of 67 means the KeepIdentity, TableLock, and KeepNulls options are enabled (1 + 2 + 64).
Default
2
Data Type
long
See also
Using DataDirect Bulk Load