DTS Programming

InsertSuccessFunctionEntry Property

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

Applies To

DTSTransformScriptProperties2 Object

Syntax

object.InsertSuccessFunctionEntry [= name]

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

Data Type

String

Modifiable

Read/write

Prototype (C/C++)

HRESULT InsertSuccessFunctionEntry(BSTR* pRetVal);

HRESULT InsertSuccessFunctionEntry(BSTR pRetVal);

Remarks

The OnInsertSuccess phase occurs when an Insert to the destination succeeds in the DataPumpTask2 or ParallelDataPumpTask object or after the success of any of the queries in the DataDrivenQueryTask2 object.

The OnInsertSuccess 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("InsertSuccessFunctionEntry") [= string]