DTS Programming
FailOnError Property
The FailOnError property specifies whether Data Transformation Services (DTS) package execution stops when there is an error in any step.
Applies To
| Package Object | Package2 Object |
Syntax
object.FailOnError [= value]
| Part | Description |
|---|---|
| object | Expression that evaluates to an object in the Applies To list |
| value | Boolean that specifies whether the package execution stops when there is an error |
Data Type
Boolean
Modifiable
Read/write
Prototype (C/C++)
HRESULT GetFailOnError(VARIANT_BOOL *pRetVal);
HRESULT SetFailOnError(VARIANT_BOOL NewValue);
Remarks
The default is FALSE.
In Microsoft® Visual Basic®, errors will not be raised for the caller of the Execute method unless FailOnError is TRUE or FailPackageOnError is TRUE for the step in which the error occurs. When that happens, the error description will identify only the step that failed. To determine the reason for failure, use the GetExecutionErrorInfo method of the step.