Define Columns

DTS Designer

DTS Designer Help

Define Columns

Use this dialog box to specify the columns and their attributes when the destination is a text file.

Options

Table columns

Define the columns in the text file. By default, all columns selected in the source are copied to the destination.

Name
Select whether or not to <ignore> a column in the destination.
Type
Select whether the data in the column is quotable or not quotable.
Size
Type the column size for a selected destination column.
Binary
Select whether or not the data in a destination column is binary.

Populate from Source

Copy the column schema as is from the source to the destination, overwriting any changes. You can still modify the columns and column attributes after selecting this option.

Execute

Use the values entered in this dialog box to define the destination.