Steps in the SQL Server Import and Export Wizard

Applies to: SQL Server SSIS Integration Runtime in Azure Data Factory

This topic describes the sequence of steps for importing and exporting data with the SQL Server Import and Export Wizard. It also contains links to the individual pages of documentation that describe each page or dialog box you see in the wizard.

This topic describes only the steps in the wizard. If you're looking for something else, see Related tasks and content.

Steps for importing and exporting data

The following table lists the steps for importing and exporting data and the corresponding pages of the wizard. Depending on the options that you select in the wizard, you typically don't see all these pages.

For a quick look at the several screens you see in a typical session, take a look at this simple end-to-end example on a single page - Get started with this simple example of the Import and Export Wizard.

Step	Wizard pages
Welcome You don't have to take any action on this page.	Welcome to SQL Server Import and Export Wizard
Pick the source of the data.	Choose a Data Source
Pick the destination for the data.	Choose a Destination
Configure the destination. (optional steps) - Create a new destination database. - If you're copying data to a text file, configure additional settings.	Create Database Configure Flat File Destination
Specify what you want to copy.	Specify Table Copy or Query Select Source Tables and Views Provide a Source Query
Configure the copy operation. (optional steps) - Create a new destination table. - Decide what to do if the wizard doesn't know how to map data types between the source and destination that you selected. - Review column mappings between source and destination. - Handle issues with converting data types between source and destination. - Preview the data to be copied.	Create Table SQL Statement Convert Types without Conversion Checking Column Mappings Review Data Type Mapping Column Conversion Details Dialog Box Preview Data Dialog Box
Copy the data. Optionally, save your settings as a SQL Server Integration Services (SSIS) package.	Save and Run Package Save SSIS Package Complete the Wizard Performing Operation

Tip

Tap the F1 key from any page or dialog box of the wizard to see documentation for the current page.

Related tasks and content

Here are some other basic tasks.

• See a quick example of how the wizard works.

  • If you prefer to see screen shots. Take a look at this simple end-to-end example on a single page - Get started with this simple example of the Import and Export Wizard.

  • If you prefer to watch a video. Watch this four-minute video from YouTube that demonstrates the wizard and explains clearly and simply how to export data to Excel - Using the SQL Server Import and Export Wizard to Export to Excel.

• Learn more about how the wizard works.

  • Learn more about the wizard. If you're looking for an overview of the wizard, see Import and Export Data with the SQL Server Import and Export Wizard.

  • Learn how to connect to data sources and destinations. If you're looking for info about how to connect to your data, select the page you want from the list here - Connect to data sources with the SQL Server Import and Export Wizard. There's a separate page of documentation for each of several commonly used data sources.

• Start the wizard. If you're ready to run the wizard and just want to know how to start it, see Start the SQL Server Import and Export Wizard.

• Get the wizard. If you want to run the wizard, but you don't have Microsoft SQL Server installed on your computer, you can install the SQL Server Import and Export Wizard by installing SQL Server Data Tools (SSDT). For more info, see Download SQL Server Data Tools (SSDT).