DTS Programming
UseFastLoad Property
The UseFastLoad property specifies whether to use the FastLoad option, where rows are processed in batches under a single transaction commit.
Applies To
| DataPumpTask Object | DataPumpTask2 Object |
Syntax
object.UseFastLoad [= value]
| Part | Description |
|---|---|
| object | Expression that evaluates to an object in the Applies To list. |
| value | Boolean that specifies whether to use the FastLoad option, if available. |
Data Type
Boolean
Modifiable
Read/write
Prototype (C/C++)
HRESULT GetUseFastLoad(VARIANT_BOOL *pRetVal);
HRESULT SetUseFastLoad(VARIANT_BOOL NewValue);
Remarks
The batch size is controlled by the InsertCommitSize property.
The FastLoad option is available if the OLE DB provider supports the IRowsetFastLoad interface.