BatchSize Property (DTS)

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 an object in the Applies To list
value Number of rows to load

Remarks

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

Data Type

Long

Modifiable

Read/write

Prototype (C/C++)

HRESULT GetBatchSize(LONG *pRetVal);

HRESULT SetBatchSize(LONG NewValue);

  


(c) 1988-98 Microsoft Corporation. All Rights Reserved.