FunctionEntry Property

DTS Programming

DTS Programming

FunctionEntry Property

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

Applies To
DataPumpTransformationScript Object DTSTransformScriptProperties2 Object
Syntax

object.FunctionEntry [= value]

Part Description
object Expression that evaluates to an object in the Applies To list
value Function to call in the script

Data Type

String

Modifiable

Read/write

Prototype (C/C++)

HRESULT GetFunctionEntry(*pRetVal);

HRESULT SetFunctionEntry(NewValue);

Remarks

In the DTSTransformScriptProperties2 object, the FunctionEntry property specifies the function name for the Transform phase. In the DataPumpTransformScript object, the Transform phase is the only transformation phase.

The script function specified by FunctionEntry has read access to the columns of the DTSSource collection and write access to the columns of the DTSDestination collection. The valid function return values are specified by the DTSTransformStatus constants.

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

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

See Also

BatchCompleteFunctionEntry Property

DataDrivenQueryTask2 Object

DataPumpTask2 Object

DTSTransformStatus

InsertFailureFunctionEntry Property

InsertSuccessFunctionEntry Property

ParallelDataPumpTask Object

PostSourceDataFunctionEntry Property

PreSourceDataFunctionEntry Property

PumpCompleteFunctionEntry Property

TransformFailureFunctionEntry Property