DTS Programming
InsertCommitSize Property
The InsertCommitSize property specifies the number of rows that are inserted in a single transaction when the FastLoad option is being used.
Applies To
| DataPumpTask Object | DataPumpTask2 Object |
Syntax
object.InsertCommitSize [= value]
| Part | Description |
|---|---|
| object | Expression that evaluates to an object in the Applies To list |
| value | Number of rows inserted as a single transaction |
Data Type
Long
Modifiable
Read/write
Prototype (C/C++)
HRESULT GetInsertCommitSize(LONG *pRetVal);
HRESULT SetInsertCommitSize(LONG NewValue);
Remarks
The default is 0. This means all inserts into the table are batched in a single transaction.