Forum Discussion
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)
========================...
Hi everyone!
I ran into the same issue recently and it was very frustrating to solve, but I finally did overcome.
My setup consisted of a Windows 11 Pro edition, using the latest SQL Server Express 2022 version. After some research, I understood that this particular version doesn't come with some integration features, which include the DTSWizard needed to import data. However, the 2022 SQL Server Developer version does allow to enable these features while installing the server.
So after some trial and error, I figured I had to uninstall the SQL SERVER EXPRESS version and delete any remenant files on my drive. This also included any Windows Registry entries for MS SQL(careful if you try this focus solely on the SQL Server entries that are created when you install the software).
After that was done I installed the 2022 SQL Server Developer version. And that fixed the issue. I can now import and export data directly from SSMS. Keep in mind that the new 2022 version doesn't install the SQL Server Native Client, like previous versions. So, it now uses the Micrsoft OLE DB Driver for SQL Server connector. Though I was still missing the AccessDatabaseEngine file, which can be downloaded seperately.
Check this video out if you are keen on watching the steps:
https://www.youtube.com/watch?v=iGzBgd0qwT4
Hope this is helpful!
I ran into the same issue recently and it was very frustrating to solve, but I finally did overcome.
My setup consisted of a Windows 11 Pro edition, using the latest SQL Server Express 2022 version. After some research, I understood that this particular version doesn't come with some integration features, which include the DTSWizard needed to import data. However, the 2022 SQL Server Developer version does allow to enable these features while installing the server.
So after some trial and error, I figured I had to uninstall the SQL SERVER EXPRESS version and delete any remenant files on my drive. This also included any Windows Registry entries for MS SQL(careful if you try this focus solely on the SQL Server entries that are created when you install the software).
After that was done I installed the 2022 SQL Server Developer version. And that fixed the issue. I can now import and export data directly from SSMS. Keep in mind that the new 2022 version doesn't install the SQL Server Native Client, like previous versions. So, it now uses the Micrsoft OLE DB Driver for SQL Server connector. Though I was still missing the AccessDatabaseEngine file, which can be downloaded seperately.
Check this video out if you are keen on watching the steps:
https://www.youtube.com/watch?v=iGzBgd0qwT4
Hope this is helpful!