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
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


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

Here are some other basic tasks.