Gets or sets the number of rows in each batch. At the end of each batch, the rows in the batch are sent to the server.

Syntax

Visual Basic

Public Property BatchSize As Integer

C#

public int BatchSize  { get; set; }

Property value

The number of rows in each batch. The default is 0.

Remarks

Setting this property to zero causes all the rows to be sent in one batch.

Setting this property to a value less than zero is an error.

If this value is changed while a batch is in progress, the current batch completes and any further batches use the new value.

See also

• SABulkCopy class
• SABulkCopy members