Export (0) Print
Expand All

SQL Server Import and Export Wizard F1 Help

Use the SQL Server Import and Export Wizard to copy and transform data between supported data sources and destinations. This section provides F1 Help for the dialog boxes that are available in the SQL Server Import and Export Wizard. The following table describes the topics in this section.

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.

Welcome to SQL Server Import and Export Wizard

Start the wizard and opt to skip the welcome page if desired.

Choose a Data Source (SQL Server Import and Export Wizard)

Select a data source and specify required connection information.

Choose a Destination (SQL Server Import and Export Wizard)

Select a data destination and specify required connection information.

Create Database (SQL Server Import and Export Wizard)

Create the destination database, when exporting to a new database.

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

Configure the parameters required to export to a flat file.

Column Mappings (SQL Server Import and Export Wizard)

Map source columns to destination columns.

Create Table SQL Statement (SQL Server Import and Export Wizard)

Create the destination table, when exporting to a new table.

Specify Table Copy or Query (SQL Server Import and Export Wizard)

Specify whether the source data consists of tables and views, or the results of a SQL query.

Select Source Tables and Views (SQL Server Import and Export Wizard)

Specify the tables and views to be exported from the data source.

Preview Data Dialog Box (SQL Server Import and Export Wizard)

View the query that the SQL Server Import and Export Wizard will send to the data source.

Review Data Type Mapping (SQL Server Import and Export Wizard)

Review detailed information about data type conversions that the wizard has to perform to make the source data compatible with the destination.

Column Conversion Details Dialog Box (SQL Server Import and Export Wizard)

Review detailed conversion information about an individual column.

Convert Types without Conversion Checking (SQL Server Import and Export Wizard)

Review the mappings that the wizard performs when the wizard cannot locate one or more of the Integration Services data type conversion and mapping files.

Provide a Source Query (SQL Server Import and Export Wizard)

Specify the query that provides the data to be exported from the data source.

Save and Execute Package (SQL Server Import and Export Wizard)

Specify whether to execute the package immediately and whether to save the package to a specified location.

Package Protection Level

Specify the level of encryption and password protection desired for the saved package.

Save SSIS Package (SQL Server Import and Export Wizard)

Specify the parameters required to save the package.

Complete the Wizard (SQL Server Import and Export Wizard)

Summarizes the options selected.

Performing Operation (SQL Server Import and Export Wizard)

Reports the progress of package execution.

Community Additions

ADD
Show:
© 2014 Microsoft