Forum Discussion
SQL Server Import and Export Wizard
Please help. I am trying use SQL server 2022 and i keep getting this error, i have tried to reinstall and also tried on another laptop and i still get the same error. I am trying to use SQL Server Import and Export Wizard and it wont open. I am using Developer edition. I have also tried downloading SQL server 2019 from the website but its not available for download.
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)
------------------------------
I had the same problem.
installed "integration services"
https://marketplace.visualstudio.com/items?itemName=SSIS.MicrosoftDataToolsIntegrationServices
then SQL Server installation Center ->
Then add features "integration services"
This resolved my problem.
Thank you very much, it works!
At first when I press the first button I need to choose a file, so I can't find where to add feature, and this problem is solved by this method. https://stackoverflow.com/questions/37871918/sql-server-is-not-a-valid-installation-folder-how-to-fix-location
- ozguvener This works even a year later . Thanks!
ozguvener After spending all day trying to fix this problem which suddenly popped up after a Windows update, your solution is the only thing that worked. Thank you!!!
- Notatall
