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.