InsertCommitSize Property (DTS)

The InsertCommitSize property specifies the number of successful InsertRows events between commit operations, if supported by the provider (for example, IRowsetFastLoad).

Applies To

DataPumpTask Object

Syntax

object.InsertCommitSize [= value]

Part	Description
object	Expression that evaluates to an object in the Applies To list
value	Number of successful InsertRows events between commit operations

Remarks

The default is 1000.

Data Type

Long

Modifiable

Read/write

Prototype (C/C++)

HRESULT GetInsertCommitSize(LONG *pRetVal);

HRESULT SetInsertCommitSize(LONG NewValue);