DTS Programming

BatchSize Property

The BatchSize property specifies the number of rows to load in a batch.

Applies To
BulkInsertTask Object

Syntax

object.BatchSize [= value]

Part Description
object Expression that evaluates to a BulkInsertTask object
value Number of rows to load

Data Type

Long

Modifiable

Read/write

Prototype (C/C++)

HRESULT GetBatchSize(LONG *pRetVal);

HRESULT SetBatchSize(LONG NewValue);

Remarks

The default is 0, which specifies that all rows are to be loaded as a single transaction.