SQL Server Management Studio (SSMS) Start the SQL Server Import and Export Wizard from SQL Server Management Studio (SSMS) This value depends on the version of SQL Server you have.Ĭ:\Program Files (x86)\Microsoft SQL Server\160\DTS\Binn for the 32-bit version.įor 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
In a Command Prompt window, run DTSWizard.exe from one of the following locations.Ĭ:\Program Files\Microsoft SQL Server\160\DTS\Binn for the 64-bit version. Run the 64-bit version of the wizard unless you know that your data source requires a 32-bit data provider.Ĭommand prompt Start the SQL Server Import and Export Wizard from the command prompt Select the SQL Server (version) Import and Export data tool you want to use. On the Start menu, find and expand folder for your SQL Server version.
Start menu Start the SQL Server Import and Export Wizard from the Start menu
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. To use the 64-bit version of the SQL Server Import and Export Wizard, you have to install SQL Server.
