As an example, the general steps required to export data from Microsoft® SQL Server™ to a text file using the DTS Export Wizard are:
Use this | To do this |
---|---|
Delimited | Align data within the file into fields, each delimited with a terminating character. All fields must be delimited with the same terminating character. |
Fixed Field | Align data within the file into fields of equal width. A field within the file has the same width for all rows of data. Each field can have a different width from other fields within the same row, however. |
File Type | Choose ANSI or Unicode, depending on the type of data in the file. |
Row Delimiter | Separate one row in the file from the next with a character sequence. Choose from:
{CR}{LF} Carriage Return Line Feed |
Column Delimiter | Separate one column from the next with a character. Choose from:
Semicolon |
Text Qualifier | Enclose text fields character used. Choose from:
Double Quotation mark{"} |
First row has column names | Specify that the first row in the text file has column headings rather than data. |
Transform... | Specify any data transformations. |