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.