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