Muokkaa

Jaa

Start the SQL Server Import and Export Wizard

  • Artikkeli

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

This article describes four ways to start the SQL Server Import and Export Wizard. Use this tool to import data from, and export data to, any supported data source.

You can start the wizard:

Tip

Another way to import data is with the SQL Server Import extension extension in Azure Data Studio.

Get the wizard

You can run the SQL Server Import and Export Wizard directly through SQL Server Management Studio (SSMS).

To run the wizard outside of SSMS, you need to have DTSWizard.exe, which you get when you install one of the following:

Note

To use the 64-bit 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-bit applications and only install 32-bit files, including the 32-bit version of the wizard.

SQL Server Management Studio (SSMS)

To start the SQL Server Import and Export Wizard from SQL Server Management Studio, follow these steps:

  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. Select one of the following options.

    • Import Data

    • Export Data

    Screenshot of start wizard SSMS.

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

Start menu

To start the SQL Server Import and Export Wizard from the Windows Start menu, DTSWizard.exe must be installed through SQL Server. Check Get the wizard for installation details.

To start the wizard from the Windows Start menu, follow these steps:

  1. On the Start menu, find and expand folder for your SQL Server version.

  2. Select the SQL Server (version) Import and Export data tool you want to use.

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

    Screenshot of Start menu find Import and Export Wizard.

Command prompt

To start the SQL Server Import and Export Wizard from the command prompt, the DTSWizard.exe must be installed either through SQL Server or through SSDT for Visual Studio 2017. The wizard that comes with Visual Studio 2019 and later can't be launched from the executable, or the command prompt. Check Get the wizard for installation details.

The path for DTSWizard.exe is different if you installed it through SQL Server, or through Visual Studio, such as the following examples:

  • C:\Program Files\Microsoft SQL Server\<##>\DTS\Binn
    • For the 64-bit version installed through SQL Server
    • The <##> correlates to the version of SQL Server. For example, 160 is for SQL Server 2022.
  • C:\Program Files (x86)\Microsoft SQL Server\<##>\DTS\Binn
    • For the 32-bit version installed through SQL Server.
    • The <##> correlates to the version of SQL Server. For example, 160 is for SQL Server 2022.
  • C:\Program Files (x86)\Microsoft Visual Studio\2017\SQL\Common7\IDE\CommonExtensions\Microsoft\SSIS\140\Binn
    • For the 32-bit version installed through SSDT for Visual Studio 2017 with SQL Server Integration Services checked in the installation wizard.

To run the SQL Server Import and Export Wizard from the command prompt, navigate to where the executable is located, and then run DTSWizard.exe.

For example, to launch the 64-bit version of the wizard from the command prompt on SQL Server 2022, run the following command:

C:\Program Files\Microsoft SQL Server\160\DTS\Binn> DTSWizard.exe

Visual Studio

To run the SQL Server Import and Export Wizard within Visual Studios 2019 and later, you need the Integration Services extension. Check Get the wizard for installation details.

In Visual Studio, open an Integration Services project, and then do one of the following things:

  • From the Project menu, select SSIS Import and Export Wizard.

    Screenshot of Start wizard Project.

    - or -

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

    Screenshot of Start wizard Packages.

Get help while the wizard is running

Tip

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

What's next?

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.

Related content