Skip to content

Latest commit

 

History

History
135 lines (88 loc) · 8.16 KB

start-the-sql-server-import-and-export-wizard.md

File metadata and controls

135 lines (88 loc) · 8.16 KB
title titleSuffix description author ms.author ms.reviewer ms.date ms.service ms.subservice ms.topic helpviewer_keywords
Start the SQL Server Import and Export Wizard
Integration Services (SSIS)
Start the SQL Server Import and Export Wizard
chugugrace
chugu
mathoma
09/27/2024
sql
integration-services
how-to
SQL Server Import and Export Wizard
starting SQL Server Import and Export Wizard
Import and Export Wizard
starting Import and Export Wizard

Start the SQL Server Import and Export Wizard

[!INCLUDE sqlserver-ssis]

This article describes four ways to start the [!INCLUDE ssNoVersion] 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 [!INCLUDE ssNoVersion] Import and Export Wizard directly through [!INCLUDE ssManStudioFull] (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 [!INCLUDE ssNoVersion] Import and Export Wizard, you have to install [!INCLUDE ssNoVersion]. 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 [!INCLUDE ssNoVersion] Import and Export Wizard from [!INCLUDE ssManStudioFull], follow these steps:

  1. In [!INCLUDE ssManStudioFull], connect to an instance of the [!INCLUDE ssNoVersion] [!INCLUDE ssDE].

  2. Expand Databases.

  3. Right-click a database.

  4. Point to Tasks.

  5. Select one of the following options.

    • Import Data

    • Export Data

    :::image type="content" source="media/start-the-sql-server-import-and-export-wizard/start-wizard-ssms.jpg" alt-text="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 [!INCLUDE ssNoVersion] 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.

    :::image type="content" source="media/start-the-sql-server-import-and-export-wizard/start-wizard-start-64.png" alt-text="Screenshot of Start menu find Import and Export Wizard.":::

Command prompt

To start the [!INCLUDE ssNoVersion] 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 [!INCLUDE ssNoVersion] 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 [!INCLUDE ssNoVersion] 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.

    :::image type="content" source="media/start-the-sql-server-import-and-export-wizard/start-wizard-project.png" alt-text="Screenshot of Start wizard Project.":::

    - or -

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

    :::image type="content" source="media/start-the-sql-server-import-and-export-wizard/start-wizard-packages.png" alt-text="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