DTS Programming

CharacterCount Property

The CharacterCount property specifies or returns the number of characters in the substring of the source column to be copied by custom transformations.

Applies To

DataPumpTransformMidString Object

Syntax

object.CharacterCount [= value]

Part	Description
object	Expression that evaluates to a DataPumpTransformMidString object
value	Number of characters in the substring to be copied

Data Type

Long

Modifiable

Read/write

Prototype (C/C++)

HRESULT CharacterCount(long* pRetVal);

HRESULT CharacterCount(long pRetVal);

Remarks

If a value less than 1 is provided for CharacterCount, a zero-length string is copied. If a value greater than the number of characters available to be copied is provided, the entire source string from the specified CharacterStart to the end of the string is copied.

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

Set transprops = transform.TransformServerProperties
transprops("CharacterCount") [= value]