Transform Data Task Properties (Destination Tab)

DTS Designer

DTS Designer Help

Transform Data Task Properties (Destination Tab)

Use this tab to configure the destination table or storage location for the results of the task. The properties to be configured will vary, depending on the characteristics of the destination data source.

Options

Table name

Select the data destination of the transformation from the list.

Create

Specify that a new table should be created as the destination. A destination table or storage area must exist before you can specify transformations.

Name

View the names of the destination columns.

Type

View the destination native data type using OLE DB data type mappings.

Nullability

View whether the destination columns allow null values. The default is true.

Size

View the width of destination columns where applicable.

Precision

View the precision of destination columns where applicable.

Scale

View the number of digits in scale where applicable.

See Also

Transform Data Task

DTS Connections