PumpCompleteFunctionEntry Property

DTS Programming

DTS Programming

PumpCompleteFunctionEntry Property

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

Applies To
DTSTransformScriptProperties2 Object
Syntax

object.PumpCompleteFunctionEntry [= name]

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

Data Type

String

Modifiable

Read/write

Prototype (C/C++)

HRESULT PumpCompleteFunctionEntry(BSTR* pRetVal);

HRESULT PumpCompleteFunctionEntry(BSTR pRetVal);

Remarks

The PostSourceData phase occurs after all other processing in the DataPumpTask2, DataDrivenQueryTask2 or ParallelDataPumpTask objects is complete.

The OnPumpComplete script function has no access to the columns of the DTSSource and DTSDestination collections. 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("PumpCompleteFunctionEntry") [= string]

See Also

BatchCompleteFunctionEntry Property

DataDrivenQueryTask2 Object

DataPumpTask2 Object

DTSTransformStatus

FunctionEntry Property

InsertFailureFunctionEntry Property

InsertSuccessFunctionEntry Property

ParallelDataPumpTask Object

PostSourceDataFunctionEntry Property

PreSourceDataFunctionEntry Property

TransformFailureFunctionEntry Property