InsertFailureFunctionEntry Property
The InsertFailureFunctionEntry property specifies or returns the name of the script function that is to be called for the OnInsertFailure transformation phase.
Applies To
| DTSTransformScriptProperties2 Object |
Syntax
object.InsertFailureFunctionEntry [= name]
| Part | Description |
|---|---|
| object | Expression that evaluates to a DTSTransformScriptProperties2 object |
| name | Name of the script function that supports the OnInsertFailure phase |
Data Type
String
Modifiable
Read/write
Prototype (C/C++)
HRESULT InsertFailureFunctionEntry(BSTR* pRetVal);
HRESULT InsertFailureFunctionEntry(BSTR pRetVal);
Remarks
The OnInsertFailure phase occurs when an Insert to the destination fails in the DataPumpTask2 or ParallelDataPumpTask object or after the failure of any of the queries in the DataDrivenQueryTask2 object.
The OnInsertFailure script function has read access to the columns of the DTSSource collection and no access to the columns of the DTSDestination collection. The only valid return values are DTSTransformStat_OK and DTSTransformStat_AbortPump.
The property also can be referenced through the TransformServerProperties collection with the following code:
Set transprops = transform.TransformServerProperties
transprops("InsertFailureFunctionEntry") [= string]
See Also
BatchCompleteFunctionEntry Property
InsertSuccessFunctionEntry Property
PostSourceDataFunctionEntry Property
PreSourceDataFunctionEntry Property