Date Time String Transformation Properties

DTS Designer

DTS Designer Help

Date Time String Transformation Properties

Use this dialog box to select the format for the source and destination date-time data used in a transformation. You can reformat the date and time source data and copy it to the destination using any of the available formats.

Options

Source

Use these options to specify the format of the source data.

Date format
Select an available date-time format from the list.
Preview
View the current date and time in the selected date format.

Destination

Use these options to specify the format of the destination data.

Date format
Select an available date-time format from the list.
Preview
View the current date and time in the selected date format.

Year 2000 cutoff date

Use to specify an integer that represents the cutoff year for interpreting two-digit years as four-digit years. A two-digit year that is less than or equal to the last two digits of the Year 2000 cutoff date is in the century that precedes the Year 2000 cutoff date. A two-digit year that is greater than the last two digits of the Year 2000 cutoff date is in the same century as the Year 2000 cutoff date.

Naming

Rename date and time information or reset the language used when copying date and time information for a transformation.

See Also

Date Time String Transformation

Transformation Types

Mapping Column Transformations