DTS Programming

OutputFormat Property

The OutputFormat property specifies or returns a string that defines the format of the datetime string in the destination column. This format string consists of tokens and delimiters, which define how components of the date and time are to be formatted. The delimiters are explicitly written to the destination column.

Applies To

DataPumpTransformDateTimeString Object

Syntax

object.OutputFormat [= 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 OutputFormat(BSTR* pRetVal);

HRESULT OutputFormat(BSTR pRetVal);

Remarks

The tokens that can be used in the InputFormat and OutputFormat properties are defined as follows.

Token	Description
yyyy	4 digit year.
yy	2 digit year.
MMMM	Month long name.
MMM	Month 3-char abbreviation.
MM	2-digit month number 01..12.
M	1- or 2-digit month number, 1..12.
dddd	Day of week long name.
ddd	Day of week 3-char abbreviation.
dd	2-digit day number 01..31.
d	1- or 2-digit day number 1..31.
hh	2-digit hours 01..12.
h	1- or 2-digit hours 1..12.
HH	2-digit hours 00..23.
H	1- or 2-digit hours 0..23.
mm	2-digit minutes 00..59.
m	1- or 2-digit minutes 0..59.
ss	2-digit seconds 00..59.
s	1- or 2-digit seconds 0..59.
f[f[f...]]]	Fraction of second, in the number of digits as "f"s specified.
tt	Symbol for A.M. or P.M.

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

Set transprops = transform.TransformServerProperties
transprops("OutputFormat") [= formatstring]