Forum Discussion

Abdelrazek-rizk's avatar
Abdelrazek-rizk
Brass Contributor
Jul 29, 2022

Error with my SQL Server 2022 preview Import and Export Wizard

  =================================== An error occurred which the SQL Server Integration Services Wizard was not prepared to handle. (SQL Server Import and Export Wizard) ========================...
brunda24's avatar
brunda24
Copper Contributor
Feb 10, 2023

Hi Ronen_Ariely 

This is the below-mentioned error we are getting when connecting to the import and export wizard. 

 

G-man777's avatar
G-man777
Copper Contributor
Feb 10, 2023

brunda24 

 

I installed SQL Express 2022 and also got this error because the Import and Export 2022 does not work for SQL Express 2022.  So either of these 2 things worked for me:

 

- SQL Import and Export 2019 (I was able to use this tool with SQL Express 2022)

- Uninstalled SQL Express 2022 and reinstalled SQL Developer 2022 (then the Import and Export 2022 tool works)

 

Hope you come right.

 

  • hamzathejaved96's avatar
    hamzathejaved96
    Copper Contributor
    Feb 18, 2023
    I tried reinstalling the Developer Version but now SQL Express 2022 is giving the error of not recognising the instance. Any idea why that might be happening? Is it maybe because my SQL Express 2022 wasn't uninstalled properly and its confusing it with old file path? Tried renaming file paths but the problem still persists 😞
    • Genesis_Escobar's avatar
      Genesis_Escobar
      Copper Contributor
      Sep 27, 2023

      hamzathejaved96  I’m having the same problem here. I also uninstalled and reinstalled it. How did you solve it? Any help would be appreciated. I’m in a rabbit hole that I can’t get out of. 😞 

    • G-man777's avatar
      G-man777
      Copper Contributor
      Mar 10, 2023

      I would say the Uninstall wasn't cleanly performed. Do it from the Command Prompt as Administrator.

      Also, check out the link just posted about the Cumulative Update 1. MS seemed to have fixed this problem in the update for SQL 2022.

       

      https://www.microsoft.com/en-us/download/confirmation.aspx?id=105013

       

      ---

       

      How to Uninstall:

       

      - Search "Services" and "Run as Administrator"
      - As "Administrator" Stop all SQL Services

      - Search "Command Prompt" and "Run as Administrator"
      - Go to setup.exe file location > cd C:\...\SQL2022-SSEI-Express\ExpressAdv_ENU
      - setup.exe /ACTION=UNINSTALL

      - Installation Wizard opens
      - Select which SQL Instance/components you wish to uninstall


      - Search "Command Prompt" and "Run as Administrator"
      - As "Administrator" from the Command Prompt, type > control panel
      - Uninstall any SQL related applications/tools you want to remove

    • LeyRowk's avatar
      LeyRowk
      Copper Contributor
      Mar 10, 2023
      This fixed on my end on SQL Express 2022.
      Check this post https://stackoverflow.com/questions/6649363/microsoft-ace-oledb-12-0-provider-is-not-registered-on-t...
      and install
      2007 Office System Driver: Data Connectivity Components
      https://www.microsoft.com/en-us/download/confirmation.aspx?id=13255

Resources