DTS Programming

TransformServer Property

The TransformServer property returns a reference to the transform server object (the class-specific transformation object) through which the properties of that object can be directly accessed.

Applies To

Transformation Object

Transformation2 Object

Syntax

[Set transform =] object.TransformServer

Part	Description
object	Expression that evaluates to an object in the Applies To list
transform	Reference to the transform server object

Data Type

Object

Modifiable

Read/write

Prototype (C/C++)

HRESULT GetTransformServer(IDispatch **pRetVal);

Remarks

You can access the properties of the class-specific transformation object directly or through the TransformServerProperties collection of the Transformation2 object.

Example

The following code creates a DataPumpTransformMidString transformation, and then references the transform server object and uses it to set the CharacterStart property:

    Dim objDataPump   As DTS.DataPumpTask
    Dim objTransform  As DTS.Transformation
    Dim objMidString  As DTSPump.DataPumpTransformMidString
    . . .
    Set objTransform = objDataPump.Transformations. _
            New("DTSPump.DataPumpTransformMidString")
    Set objMidString = objTransform.TransformServer
    objMidString.CharacterStart = 5