Forum Discussion

Abdelrazek-rizk's avatar
Abdelrazek-rizk
Brass Contributor
Jul 28, 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) ========================...
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 17, 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 09, 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