Determines when the driver uses bulk load for insert, update, delete, or batch operations. If the Enable Bulk Load option is set to 1 (enabled) and the number of rows affected by an insert, update, delete, or batch operation exceeds the threshold specified by this option, the driver uses SQL Server bulk load protocol to perform the operation.
Valid Values
0 | x
where:
x
is a positive integer that represents a threshold (number of rows).
Behavior
If set to 0, the driver always uses bulk load to execute insert, update, delete, or batch operations.
If set to x, the driver only uses bulk load if the Enable Bulk Load option is enabled and the number of rows to be updated by an insert, update, delete, or batch operation exceeds the threshold. If the operation times out, the driver returns an error.
Notes
If the Enable Bulk Load option is set to false, this option is ignored.
If the Enable Bulk Load option is set to false, this option is ignored.