Text File Properties

DTS Designer

DTS Designer Help

Text File Properties

Use this dialog box to set the data format of the source or destination text file. There are two data formats from which to choose: delimited and fixed field.

Options

Delimited

Specify that the source or destination text file uses delimiter characters to indicate columns.

Fixed field

Specify that the data in the source or destination text file is aligned into equal width columns.

Skip rows

Specify the number of rows you want skipped in a text file. This option only applies when the text file is used for source data.

First row has column names

Indicate that the first row in the specified file consists of column names.

File type

Specify whether the data file is ANSI (default), Unicode, or OEM.

Row delimiter

Specify whether the character that delimits rows in the data file is carriage return/line feed {CR}{LF} (default), carriage return {CR}, or line feed {LF}. You can also type another character.

Text qualifier

Specify whether quotation marks are to be used to qualify text in the data file.