Select File Format

DTS Import/Export Wizard Help

DTS Import/Export Wizard Help

Select File Format

Use this dialog box to specify the formatting of a source or destination text file. Columns and rows in the text file may be of fixed length or delimited with special characters.

Note  If importing from an instance of Microsoft® SQL Server™ to a text file, column sizes may default to 2 gigabytes (GB). If you need to adjust the column size setting, click Transform in the Select destination file format dialog box to modify columns. When copying data from a text file to a new SQL Server table, the column sizes may default to varchar (255).

Options

Delimited

Specify that data within the file is aligned into fields and that each field is delimited with the same terminating character.

Fixed Field

Specify that data within the file is aligned into fields of equal width. A field within the file has the same width for all rows of data. However, each field can have a width different from other fields within the same row.

File type

Specify file type by clicking ANSI, OEM, or Unicode, depending on the type of data in the file. If you click ANSI or OEM, the data will be interpreted as belonging to the code page that is current on the computer executing the package.

Row delimiter

Specify that each row in the file is separated from the next with a character sequence. Click one of the following: {CR} (carriage return); {LF} (line feed); Semicolon; Comma; Tab; Vertical Bar. You also can type in a character to use as the row delimiter. You can also click <none> if the file is a fixed field file.

Text qualifier

Specify which character marks were used in the delimited data file to qualify text. Click one of the following: Double Quote {"}; Single Quote {'}; <none>. You also can type in a character to use as the text qualifier. If the text was not delimited, but the file is not a Fixed field file, then this property can be left to the default of Double Quote {"} or changed to <none>.

Skip rows

Specify the number of rows from the start of the file that you do not want copied. This field works together with the First row has column names field. If the First row has column names check box is not selected, then the number of rows skipped is equal to the number typed here. If the First row has column names check box is checked, then the number of rows skipped starts counting after the first row of column headings has been counted.

First row has column names

Specify that the first row in the text file has column headings rather than data.

Transform

Display the Column Mappings and Transformations dialog box, where you can customize the mapping of columns and add transformations to the copied data.