1

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.

barrlitt
  • 11
  • 4
  • Have you considered upgrading SSMS? – Charlieface Jun 30 '22 at 08:49
  • @Charlieface I suspect that's what caused it. – AlwaysLearning Jun 30 '22 at 09:49
  • Have your IT team checked the Application logs in Event Viewer? There are sometimes useful messages in there from DTSWizard.exe containing codes that can point you in the correct direction. Also, what type of file/s are you trying to import when this happens? – AlwaysLearning Jun 30 '22 at 09:50
  • 1
    Also... SSMS 15.0.18382.0? That's a pretty old release (April 15, 2021). Why aren't they installing something current? – AlwaysLearning Jun 30 '22 at 09:53
  • Thanks for the feedback @Charlieface we're at the mercy of our IT department, we don't have any admin privileges. – barrlitt Jun 30 '22 at 22:45
  • Thanks @AlwaysLearning I'll ask them to check thanks. Am trying to import an .xlsx file but I don't even get to the stage that asks for the file location it just errors immediately after selecting Import Data from Tasks. We're a large multinational company, software releases are always miles behind the latest available! ;) – barrlitt Jun 30 '22 at 22:45

1 Answers1

0

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.

Tai
  • 1