Am trying to use the Import and Export Wizard within Microsoft SQL Server Management Studio (right click database name > Tasks > Import Data) but immediately get this error;
SQL Server Import and Export Wizard has stopped working
This process has been working fine until this week when IT have upgraded us from MSSMS v17.6 to v18.9 (component and version info below)
SQL Server Management Studio 15.0.18382.0
SQL Server Management Objects (SMO) 16.100.46337.53
Microsoft Analysis Services Client Tools 15.0.19535.0
Microsoft Data Access Components (MDAC) 10.0.19041.1
Microsoft MSXML 3.0 6.0
Microsoft .NET Framework 4.0.30319.42000
Operating System 10.0.19044
IT are unable to troubleshoot and resolve the problem, but I'm guessing something is wrong with the install of the newer version of MSSMS. Any ideas or assistance to aid resolution gratefully received.
It happened to me, too. I read some threads saying that if you install SQL Server Data Tool, the wizard and SQL Job property window stop working altogether. Launching the wizard within Visual Studio works fine.