DTS Programming

InputFormat Property

The InputFormat property specifies or returns a string that defines the format of the datetime string in the source column. This format string consists of tokens and delimiters: the tokens represent components of the date and time, and the delimiters must explicitly appear in the source column.

Applies To

DataPumpTransformDateTimeString Object

Syntax

object.InputFormat [= formatstring]

Part	Description
object	Expression that evaluates to a DataPumpTransformDateTimeString object.
formatstring	String consisting of tokens and delimiters, which define the format of the source column.

Data Type

String

Modifiable

Read/write

Prototype (C/C++)

HRESULT InputFormat(BSTR* pRetVal);

HRESULT InputFormat(BSTR pRetVal);

Remarks

For more information about token definitions, see OutputFormat Property.

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

Set transprops = transform.TransformServerProperties
transprops("InputFormat") [= name]