TransformFailureFunctionEntry Property

DTS Programming

DTS Programming

TransformFailureFunctionEntry Property

The TransformFailureFunctionEntry property specifies or returns the name of the script function that is to be called for the OnTransformFailure transformation phase.

Applies To
DTSTransformScriptProperties2 Object
Syntax

object.TransformFailureFunctionEntry [= name]

Part Description
object Expression that evaluates to a DTSTransformScriptProperties2 object
name Name of the script function that supports the OnTransformFailure phase

Data Type

String

Modifiable

Read/write

Prototype (C/C++)

HRESULT TransformFailureFunctionEntry(BSTR* pRetVal);

HRESULT TransformFailureFunctionEntry(BSTR pRetVal);

Remarks

The OnTransformFailure phase occurs after the Transform phase returns DTSTransformStat_Error or DTSTransformStat_ExceptionRow, in the DataPumpTask2, DataDrivenQueryTask2 or ParallelDataPumpTask objects.

The OnTransformFailure script function has read access to the columns of the DTSSource collection and write access to the columns of the DTSDestination collection. Any return values that are valid during the Transform phase can be returned.

The property also can be referenced through the TransformServerProperties collection with the following code:

Set transprops = transform.TransformServerProperties
transprops("TransformFailureFunctionEntry") [= string]

See Also

BatchCompleteFunctionEntry Property

DataDrivenQueryTask2 Object

DataPumpTask2 Object

DTSTransformStatus

FunctionEntry Property

InsertFailureFunctionEntry Property

InsertSuccessFunctionEntry Property

ParallelDataPumpTask Object

PostSourceDataFunctionEntry Property

PreSourceDataFunctionEntry Property

PumpCompleteFunctionEntry Property