Start the SQL Server Import and Export Wizard

  • Article
  • 4 minutes to read

Applies to: yesSQL Server (all supported versions) yes SSIS Integration Runtime in Azure Data Factory

Start the SQL Server Import and Export Wizard in 1 of the ways that is described in this topic to import data from and export data to any supported information source.

Important

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

You can start the wizard:

  • From the Showtime card.
  • From the command prompt.
  • From SQL Server Management Studio (SSMS).
  • From Visual Studio with SQL Server Data Tools (SSDT).

Prerequisite - Is the magician installed on your reckoner?

If you desire to run the wizard, but you don't have Microsoft SQL Server installed on your estimator, you can install the SQL Server Import and Export Wizard by installing SQL Server Information Tools (SSDT). For more info, meet Download SQL Server Information Tools (SSDT).

Annotation

To use the 64-flake version of the SQL Server Import and Export Wizard, you have to install SQL Server. SQL Server Data Tools (SSDT) and SQL Server Management Studio (SSMS) are 32-flake applications and only install 32-fleck files, including the 32-scrap version of the wizard.

Starting time bill of fare

Offset the SQL Server Import and Export Magician from the Start menu

  1. On the Start menu, detect and aggrandize Microsoft SQL Server 20xx.

  2. Click one of the post-obit options.

    • SQL Server 20xx Import and Export Data (64-scrap)
    • SQL Server 20xx Import and Export Information (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

Command prompt

Start the SQL Server Import and Export Wizard from the control prompt

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

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

    • 140 = SQL Server 2017. This value depends on the version of SQL Server you accept.

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

    • 140 = SQL Server 2017. This value depends on the version of SQL Server y'all have.

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

Start wizard cmd

SQL Server Direction Studio (SSMS)

Start the SQL Server Import and Consign Wizard from SQL Server Management Studio (SSMS)

  1. In SQL Server Direction 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 ane of the post-obit options.

    • Import Information

    • Consign Data

    Start wizard SSMS

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

Visual Studio

Start the SQL Server Import and Export Sorcerer from Visual Studio with SQL Server Data Tools (SSDT)

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

  • On the Project menu, click SSIS Import and Consign Sorcerer.

    Start wizard Project

    - or -

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

    Start wizard Packages

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

Get the sorcerer

If you desire to run the wizard, merely you don't have Microsoft SQL Server installed on your figurer, you can install the SQL Server Import and Export Sorcerer by installing SQL Server Data Tools (SSDT). For more info, see Download SQL Server Data Tools (SSDT).

Get help while the magician is running

Tip

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

What'south next?

When you start the magician, the first page is Welcome to SQL Server Import and Export Sorcerer. You don't accept to take any activeness on this folio. For more info, run into Welcome to SQL Server Import and Export Sorcerer.

Related tasks and content

Here are another bones tasks.

  • See a quick example of how the sorcerer works.

    • If you prefer to run across screenshots. Await at this unproblematic example on a single page - Go started with this simple example of the Import and Export Sorcerer.

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

    • Acquire more nigh how the wizard works.

      • Learn more well-nigh the wizard. If y'all're looking for an overview of the sorcerer, meet Import and Export Information with the SQL Server Import and Export Magician.
      • Learn about the steps in the wizard. If you're looking for info about the steps in the wizard, see Steps in the SQL Server Import and Consign Magician. There'south besides a dissever page of documentation for each page of the wizard.
      • Learn how to connect to data sources and destinations. If you're looking for info about how to connect to your information, select the page you desire from the list here - Connect to information sources with the SQL Server Import and Export Wizard. There's a divide page of documentation for each of several ordinarily used data sources.

Next steps

  • Import and Consign Data with the SQL Server Import and Export Wizard
  • Go started with this simple instance of the Import and Consign Wizard