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 Abdelrazek-rizk, I tested it in several different configuration and found no issue. Are you using the SSMS wizard or visual studio? Can you elaborate more and add a screenshot or two on how we can reproduce the issue. In the meantime, please remember that this is community forum, in order to contact the product team you can send a feedback to the team in this site: https://feedback.azure.com/d365community/forum/04fe6ee0-3b25-ec11-b6e6-000d3a4f0da0
Hi Ronen_Ariely
This is the below-mentioned error we are getting when connecting to the import and export wizard.
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.
Ronen_Ariely
thanks i solve it by running the installation agine and it fix it- I am glad to hear the issue solved 🙂
