The FailPackageOnError property specifies whether Data Transformation Services (DTS) package execution stops when there is an error in the step with which it is associated.
object.FailPackageOnError [= value]
| Part | Description |
|---|---|
| Object | Expression that evaluates to a Step2 object |
| Value | Whether the package execution stops when there is an error in the step |
Boolean
Read/write
HRESULT GetFailPackageOnError(VARIANT_BOOL *pRetVal);
HRESULT SetFailPackageOnError(VARIANT_BOOL NewValue);
The default is FALSE.
In Microsoft® Visual Basic®, errors will not be raised for the caller of the Execute method unless the package 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.