The DataPumpOptions property returns or sets extended Data Transformation Services (DTS) data pump options.
object.DataPumpOptions [= value]
| Part | Description |
|---|---|
| object | Expression that evaluates to a DataPumpTask2 object |
| value | Value that specifies the extended options |
Long
Read/write
HRESULT GetDataPumpOptions(long *pRetVal);
HRESULT SetDataPumpOptions(long NewValue);
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. |