skip to main content
DataDirect Connect Drivers : Microsoft SQL Server Driver : Configuring Bulk Load
  
Configuring Bulk Load
The driver supports DataDirect Bulk Load, a feature that allows your application to send large numbers of rows of data to a database. See Using DataDirect Bulk Load for more information. See Permissions for Bulk Load from a CSV File for information about granting permissions for bulk loading from a CSV file.
The following table summarizes the connection properties that affect how bulk load works with the SQL Server driver.
Table 69. Summary: Bulk Load Properties for the SQL Server Driver
Property
Description
BulkLoadBatchSize
Provides a suggestion to the driver for the number of rows to load to the database at a time when bulk loading data. The default is 2048.
BulkLoadOptions
Enables bulk load protocol options for batch inserts that the driver can take advantage of when the EnableBulkLoad property is set to a value of true. The default is 2 (TableLock option assigns a table lock for the duration of the bulk copy operation).
EnableBulkLoad
Specifies whether the driver uses the native bulk load protocols in the database instead of the batch mechanism for batch inserts. The default is false.