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.