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