Specifies the mode used for executing batch operations when inserting data into SQL Server.

Possible Values

Data Type

string

Default Value

"STANDARD"

Remarks

This property controls how the server performs bulk inserts into SQL Server.

It supports two modes:

• STANDARD: Uses standard SQL INSERT, UPDATE, and DELETE statements for batch operations. This mode provides broad compatibility and supports full SQL functionality.
• BCP: Uses SQL Server’s native BulkCopy (BCP) protocol to transfer data directly through a lower-level TCP connection. This method supports only INSERT operations and can offer improved performance for large data loads.

The BCP mode is limited to inserting data and does not support updates or deletes. Additionally, some environments may have firewall or network rules that restrict the lower-level communication BCP requires.

This property is useful for controlling the performance and behavior of bulk data operations. Use BCP when performance is critical and only insert operations are needed. Use STANDARD for broader SQL support, including updates and deletes.

Additional Information

BCP mode may require additional server configuration to allow TCP-level bulk transfers. Ensure that firewall settings and SQL Server permissions support BCP access if you choose this mode.