Start the SQL Server Import and Export Wizard

 

Updated: January 12, 2017

You can start the SQL Server Import and Export Wizard in one of the following ways to import from or export to any supported data source. This topic describes the steps for each method.

You can also start the wizard from Visual Studio with SQL Server Data Tools (SSDT), if you have a SQL Server Integration Services project open.

This topic describes only how to start the wizard. Here are some other basic tasks.

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

  1. On the Start menu, click All apps.

  2. Find and expand Microsoft SQL Server 2016.

  3. Click one of the following options.

    • SQL Server 2016 Import and Export Data (64-bit)

    • SQL Server 2016 Import and Export Data (32-bit)

Run the 64-bit version of the wizard unless you know that your data source requires a 32-bit data provider.

Start wizard Start

In a Command Prompt window, run DTSWizard.exe from one of the following locations.

  • C:\Program Files\Microsoft SQL Server\130\DTS\Binn for the 64-bit version.

  • C:\Program Files (x86)\Microsoft SQL Server\130\DTS\Binn for the 32-bit version.

Run the 64-bit version of the wizard unless you know that your data source requires a 32-bit data provider.

Start wizard cmd

  1. In SQL Server Management Studio, connect to an instance of the SQL Server Database Engine.

  2. Expand Databases.

  3. Right-click a database.

  4. Point to Tasks.

  5. Click one of the following options.

    • Import Data

    • Export Data

Start wizard SSMS

If you don't have SQL Server installed, or you have SQL Server but don't have SQL Server Management Studio installed, see Download SQL Server Management Studio (SSMS).

In Visual Studio with SQL Server Data Tools (SSDT), with an Integration Services project open, do one of the following things.

  • On the Project menu, click SSIS Import and Export Wizard.

    Start wizard Project

    - or -

  • In Solution Explorer, right-click the SSIS Packages folder, and then click SSIS Import and Export Wizard.

    Start wizard Packages

If you don't have Visual Studio installed, or you have Visual Studio but don't have SQL Server Data Tools installed, see Download SQL Server Data Tools (SSDT).

System_CAPS_ICON_tip.jpg Tip

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

When you start the wizard, the first page is Welcome to SQL Server Import and Export Wizard. You don't have to take any action on this page. For more info, see Welcome to SQL Server Import and Export Wizard.

Community Additions

ADD
Show: