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)
------------------------------
7 Replies
- ozguvenerCopper Contributor
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.
- Fabi GowerCopper Contributor
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!!!
- ozguvenerCopper ContributorNotatall
- vidushi101Copper Contributorozguvener This works even a year later . Thanks!
- ProchefCopper Contributor
Please i really need a help in loading my excel data to my SQL Server Management Studio 2022, it keep sowing me this error
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
------------------------------pls how can i solve the problem.
- ozguvenerCopper ContributorSory for not usefull answer, i am far away form the topic for a long time .