DTS Programming

PreSourceDataFunctionEntry Property

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

Applies To

DTSTransformScriptProperties2 Object

Syntax

object.PreSourceDataFunctionEntry [= name]

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

Data Type

String

Modifiable

Read/write

Prototype (C/C++)

HRESULT PreSourceDataFunctionEntry(BSTR* pRetVal);

HRESULT PreSourceDataFunctionEntry(BSTR pRetVal);

Remarks

The PreSourceData phase occurs before the first source row is processed in the DataPumpTask2 or DataDrivenQueryTask2 objects, or before the first row of a constituent rowset is processed in the source hierarchical rowset of the ParallelDataPumpTask object.

The PreSourceData script function has no 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("PreSourceDataFunctionEntry") [= string]