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.