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)
========================...
You have to add sql server integration services to your sql server installation. I just did this with an installation of 2022 and it worked to fix this error.
This only seems to apply to SQL Server Developer, Standard & Enterprise. Integration Services IS NOT supported or available for SQL Express:
https://learn.microsoft.com/en-us/sql/integration-services/install-windows/install-integration-services?view=sql-server-ver16#complete
---
Install Integration Services
After you review the installation requirements for SQL Server and ensure that your computer meets those requirements, you're ready to install Integration Services.
If you don't already have Microsoft SQL Server, download a free Developer Edition, from https://www.microsoft.com/sql-server/sql-server-downloads. SSIS isn't included with the Express edition of SQL Server.
(hope this helps someone)
Can you explain how you installed? I am having the same issue rvora
