FailPackageOnError Property

DTS Programming

DTS Programming

FailPackageOnError Property

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.

Applies To
Step2 Object
Syntax

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

Data Type

Boolean

Modifiable

Read/write

Prototype (C/C++)

HRESULT GetFailPackageOnError(VARIANT_BOOL *pRetVal);

HRESULT SetFailPackageOnError(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 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.

See Also

Execute Method

FailOnError Property

GetExecutionErrorInfo Method