DTS Programming

TransformServerProperties Property

The TransformServerProperties property returns a reference to a Properties collection containing the properties of the transform server object (the class-specific transformation object).

Applies To

Transformation Object

Transformation2 Object

Syntax

object.TransformServerProperties

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

Data Type

Properties

Modifiable

Read-only

Prototype (C/C++)

HRESULT GetTransformServerProperties(IDTSProperties **pRetVal);

Remarks

You can use the TransformServerProperties property to access the properties of the class-specific transformation object without creating a reference to that object.

Example

The following code creates a DataPumpTransformMidString transformation, and then references the CharacterStart property through the TransformServerProperties property:

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