SQL Server Import and Export Wizard

Question

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)

------------------------------

ozguvener · Answer

Olly_23&nbsp;I had the same problem.installed "integration services"https://marketplace.visualstudio.com/items?itemName=SSIS.MicrosoftDataToolsIntegrationServicesthen SQL Server installation Center -&gt;Then add features&nbsp;"integration services"&nbsp;&nbsp;This resolved my problem.&nbsp;&nbsp;&nbsp;

lin688 · Answer

ozguvener&nbsp;Thank you very much, it works!&nbsp;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&nbsp;&nbsp;

vidushi101 · Answer

ozguvener This works even a year later . Thanks!

fabi gower · Answer

ozguvener&nbsp;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.&nbsp; Thank you!!!

prochef · Answer

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.

ozguvener

Forum Discussion

SQL Server Import and Export Wizard

7 Replies

Resources