DTS Programming
DataPumpOptions Property
The DataPumpOptions property returns or sets extended Data Transformation Services (DTS) data pump options.
Applies To
| DataPumpTask2 Object |
Syntax
object.DataPumpOptions [= value]
| Part | Description |
|---|---|
| object | Expression that evaluates to a DataPumpTask2 object |
| value | Value that specifies the extended options |
Data Type
Long
Modifiable
Read/write
Prototype (C/C++)
HRESULT GetDataPumpOptions(long *pRetVal);
HRESULT SetDataPumpOptions(long NewValue);
Remarks
The following table lists the valid values for the DataPumpOptions property.
| Value | Description |
|---|---|
| 0 | Default |
| 1 | Commits all successful batches including the final batch, even if the data pump terminates. Use this option to support restartability. |