DTS Programming

UpperCaseString Property

The UpperCaseString property specifies or returns a value indicating whether the alphabetical characters in the source column string copied by transformations are all converted to uppercase characters.

Applies To

DataPumpTransformMidString Object

DataPumpTransformTrimString Object

Syntax

transerver.UpperCaseString [= boolean]

Part	Description
transerver	Expression that evaluates to an object from the Applies To list.
boolean	Boolean that specifies whether the alpha characters in the source string are converted to uppercase. Default is FALSE.

Data Type

Boolean

Modifiable

Read/write

Prototype (C/C++)

HRESULT UpperCaseString(VARIANT_BOOL* pRetVal);

HRESULT UpperCaseString(VARIANT_BOOL pRetVal);

Remarks

The property also can be referenced through the TransformServerProperties collection with the following code:

Set transprops = transform.TransformServerProperties
transprops("UpperCaseString") [= boolean]