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)
===================================
Could not load file or assembly 'Microsoft.DataTransformationServices.ScaleHelper, Version=16.0.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91' or one of its dependencies. The system cannot find the file specified. (DTSWizard)
------------------------------
Program Location:
at Microsoft.SqlServer.Dts.DtsWizard.DTSWizardForm.GetPageSize()
at Microsoft.SqlServer.Management.UI.WizardForm.OnLoad(EventArgs args)
at System.Windows.Forms.Form.OnCreateControl()
at System.Windows.Forms.Control.CreateControl(Boolean fIgnoreVisible)
at System.Windows.Forms.Control.CreateControl()
at System.Windows.Forms.Control.WmShowWindow(Message& m)
at System.Windows.Forms.Control.WndProc(Message& m)
at System.Windows.Forms.Form.WmShowWindow(Message& m)
at System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)
TITLE: SQL Server Import and Export Wizard
------------------------------
An error occurred which the SQL Server Integration Services Wizard was not prepared to handle.
------------------------------
ADDITIONAL INFORMATION:
Could not load file or assembly 'Microsoft.DataTransformationServices.ScaleHelper, Version=16.0.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91' or one of its dependencies. The system cannot find the file specified. (DTSWizard)
------------------------------
BUTTONS:
OK
------------------------------
31 Replies
- 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! There are different ways to verify it:
1) You can try repairing by SQL server integration services wizard. You can fix it by In program and features on control panel, going to SQL server version and try repairing on it.
2)Check on the version of SSMS.
I hope this would help you.- Ronen_Ariely What are you on? Install a fresh install of Windows 10 and make sure you've installed all your updates. Then install SQL Server 2012. I have done this on 5 workstations and this error appears. Every single time.
- The Cumulative Update 1 for SQL Server 2022 has fixed the problem. Check the release notes:
https://learn.microsoft.com/en-us/troubleshoot/sql/releases/sqlserver-2022/cumulativeupdate1#2008855Thank you! I'm going to try this, installing this Cumulative Update 1, and then not using SQL Developer 2022, but SQL Express 2022, which is what I want to be using.
Thanks for this info, I will try this!
- 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-the-local-machine
and install
2007 Office System Driver: Data Connectivity Components
https://www.microsoft.com/en-us/download/confirmation.aspx?id=13255- You are the best! I searched days for a solution and tried all bunch of recommendation. This fixed my issue with importing excel files to SQL. Thank you so much! You are a life saver!
I had the same issue and this is how I resolved it:
I was trying to import an Excel file into SQL Server 2022 and got the same error. I uninstalled SQL Express 2022 and instead installed SQL Developer 2022. Then I installed integration services using the link https://www.mssqltips.com/sqlservertip/6635/install-ssis/.
This solved the issue for me and I was able to import excel files
As workaround suggestion for all to open successfully an instance of Import/Export wizard: from SSMS (Sql Server Management Studio) right click on a database, then Tasks, then click on Import Data or Export Data.
Thanks ArmandoContestabile. This was the be answer. Works like a charm, direct access. No further issues.
ArmandoContestabileFrom SSMS the wizard only supports 32 bit files not the 64 bit ones
- Right, but as said it would be just a workaround until a final fix is released. And the final fix has been released in the CU1, please check previous posts.
- Yes! So a 3rd way to deal with this error!! 🙂
I installed SQL Server 2022 Developer on Windows 10 Enterprise 20H2. Same error for me launching SQL Server Import Export Wizard (64 bit). I have tried to launch as normal user and as administrator. Both fail.
- 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
- I had exactly the same problem. But I reinstalled SQL Server 2022 and the problem persits.
I have the same problem and reinstalling has not solved the problem
ngcebothadebeonly solution that worked for me was to uninstall SQL Server 2022 and install SQL Server 2019. Now at least I can import from the wizard.
