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 Im...
ozguvener's avatar
ozguvener
Copper Contributor
Jan 18, 2023

Olly_23 

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 Gower's avatar
    Fabi Gower
    Copper Contributor
    Jun 17, 2024

    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!!!

    • ozguvener's avatar
      ozguvener
      Copper Contributor
      Jun 18, 2024
      Notatall
  • vidushi101's avatar
    vidushi101
    Copper Contributor
    Jun 15, 2024
    ozguvener This works even a year later . Thanks!
  • Prochef's avatar
    Prochef
    Copper Contributor
    Feb 08, 2024

    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
      Jun 15, 2024
      Sory for not usefull answer, i am far away form the topic for a long time .
  • Lin688's avatar
    Lin688
    Copper Contributor
    Jan 24, 2023

    ozguvener 

    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

     

     

Resources