TechNet
Export (0) Print
Expand All

Configure Flat File Destination (SQL Server Import and Export Wizard)

 

Updated: July 28, 2016

Applies To: SQL Server 2016

If you selected a flat file destination, the SQL Server Import and Export Wizard shows Configure Flat File Destination after you specify that you want to copy an entire table or after you provide a query.

On this page, you specify formatting options for the destination flat file. Optionally, you review the mapping of individual columns and preview sample data.

The following screen shot shows the Configure Flat File Destination page of the Wizard.

In this example, the user wants to end each row of data in the output with a carriage return-line feed combination, and to separate columns of data within each row with a comma.

Configure flat file page of the Import and Export Wizard

Options

Source table or view
The name of the table or view.

Row delimiter
Select from the list of delimiters for rows. There is no option to specify a custom row delimiter.

ValueDescription
{CR}{LF}Delimit rows with a carriage return-line feed combination.
{CR}Delimit rows with a carriage return.
{LF}Delimit rows with a line feed.
Semicolon {;}Delimit rows with a semicolon.
Colon {:}Delimit rows with a colon.
Comma {,}Delimit rows with a comma.
Tab {t}Delimit rows with a tab.
Vertical bar {|}Delimit rows with a vertical bar.

Column delimiter
Select from the list of delimiters for columns. There is no option to specify a custom column delimiter.

ValueDescription
{CR}{LF}Delimit columns with a carriage return-line feed combination.
{CR}Delimit columns with a carriage return.
{LF}Delimit columns with a line feed.
Semicolon {;}Delimit columns with a semicolon.
Colon {:}Delimit columns with a colon.
Comma {,}Delimit columns with a comma.
Tab {t}Delimit columns with a tab.
Vertical bar {|}Delimit columns with a vertical bar.

Optional actions

Edit mappings
Optionally click Edit mappings to display the Column Mappings dialog box for the selected table. Use the Column Mappings dialog box to do the following things,

  • Review the mapping of individual columns between the source and the destination.
  • Copy only a subset of columns by selecting ignore in the Destination column of the Column Mappings dialog box for columns that you don't want to copy.

For more info, see Column Mappings.

Preview
Optionally click Preview to preview up to 200 rows of sample data in the Preview Data dialog box. This helps you to confirm that the wizard is going to copy the data that you want to copy. For more info, see Preview Data.

After you preview the data, you may want to change the options that you selected on previous pages of the wizard. To make these changes, on the Configure Flat File Destination page, click Back to return to previous pages where you can change your selections.

After you specify formatting options for the destination flat file, the next page is Save and Execute Package. On this page, you specify whether you want to run the operation immediately. Depending on your configuration, you may also be able to save the SQL Server Integration Services package created by the wizard to customize it and to reuse it. For more info, see Save and Run Package.

To return to the main page about the SQL Server Import and Export Wizard and how it works, see SQL Server Import and Export Wizard.

Community Additions

ADD
Show:
© 2016 Microsoft