Forum Discussion

Olly_23's avatar
Olly_23
Copper Contributor
Jan 18, 2023

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

    • Fabi Gower's avatar
      Fabi Gower
      Copper 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!!!

    • Prochef's avatar
      Prochef
      Copper 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.

      ozguvener 

      • ozguvener's avatar
        ozguvener
        Copper Contributor
        Sory for not usefull answer, i am far away form the topic for a long time .

Resources