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 Creating Packages 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: Start 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.
| Topic | Description |
|---|---|
Start the wizard and opt to skip the welcome page if desired. |
|
Select a data source and specify required connection information. |
|
Select a data destination and specify required connection information. |
|
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. |
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. |
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. |
Specify the level of encryption and password protection desired for the saved package. |
|
Specify the parameters required to save the package. |
|
Summarizes the options selected. |
|
Reports the progress of package execution. |