• Article

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

Use the Configure Flat File Destination page to specify formatting options for the destination flat file, and to preview results before continuing.

To learn more about this wizard, see Importing and Exporting Data by Using the SQL Server Import and Export Wizard. To learn about the options for starting the wizard, as well as the permissions required to run the wizard successfully, see How to: Run the SQL Server Import and Export Wizard.

The purpose of the SQL Server Import and Export Wizard is to copy data from a source to a destination. The wizard can also create a destination database and destination tables for you. However, if you have to copy multiple databases or tables, or other kinds of database objects, you should use the Copy Database Wizard instead. For more information, see Using the Copy Database Wizard.

Options

  • Source flat file
    The name of the destination file.

  • Row delimiter
    Select from the list of delimiters for rows.

    Value

    Description

    {CR}{LF}

    The row is delimited by a carriage return-line feed combination.

    {CR}

    The row is delimited by a carriage return.

    {LF}

    The row is delimited by a line feed.

    Semicolon {;}

    The row is delimited by a semicolon.

    Colon {:}

    The row is delimited by a colon.

    Comma {,}

    The row is delimited by a comma.

    Tab {t}

    The row is delimited by a tab.

    Vertical bar {|}

    The row is delimited by a vertical bar.

  • Column delimiter
    Select from the list of delimiters for columns.

    Value

    Description

    {CR}{LF}

    The columns are delimited by a carriage return-line feed combination.

    {CR}

    The columns are delimited by a carriage return.

    {LF}

    The columns are delimited by a line feed.

    Semicolon {;}

    The columns are delimited by a semicolon.

    Colon {:}

    The columns are delimited by a colon.

    Comma {,}

    The columns are delimited by a comma.

    Tab {t}

    The columns are delimited by a tab.

    Vertical bar {|}

    The columns are delimited by a vertical bar.

  • Preview
    View in the Preview Data dialog box the results of the selected formatting options for the destination flat file.

  • Edit transform
    Delete rows, append rows, and configure columns in the destination file by using the Column Mappings dialog box.