DTS Programming

CharacterStart Property

The CharacterStart property specifies or returns the starting position of the substring of the source column to be copied by custom transformations.

Applies To

DataPumpTransformMidString Object

Syntax

object.CharacterStart [= value]

Part	Description
object	Expression that evaluates to a DataPumpTransformMidString object
value	Position of the starting character of the substring to be copied

Data Type

Long

Modifiable

Read/write

Prototype (C/C++)

HRESULT CharacterStart(long* pRetVal);

HRESULT CharacterStart(long pRetVal);

Remarks

If the substring starts at the first character of the source column, the property has the value of 1. If a value less than 1 is provided, 1 is used. If a value greater than the number of characters in the source string is provided, a zero-length string is copied.

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

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