SQL Import and export wizard is not working

Francis AT 20 Reputation points


I am trying to import an excel file into sql server, and followed one of the videos. He used import and export data and succeeded. Mine is being shown an error. Below is the error details. anyone direct me the way please?

TITLE: SQL Server Import and Export Wizard

An error occurred which the SQL Server Integration Services Wizard was not prepared to handle.


Could not load file or assembly 'Microsoft.DataTransformationServices.ScaleHelper, Version=, Culture=neutral, PublicKeyToken=89845dcd8080cc91' or one of its dependencies. The system cannot find the file specified. (DTSWizard)



SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
13,321 questions
0 comments No comments
{count} votes

2 answers

Sort by: Most helpful
  1. Sreeju Nair 12,186 Reputation points

    In what edition of SQL Server you are trying to import, is it SQL Server Express Edition, not all features are available in express edition. You may refer the following link to see the supported features by edition.


    Also try to install / reinstall SSIS, in your server to ensure that it is properly installed. Refer the following links.



    Hope this helps

    0 comments No comments

  2. PercyTang-MSFT 12,426 Reputation points Microsoft Vendor

    Hi @Francis AT

    The error message indicates that there is a problem with SSIS. You can reinstall SSIS by following the link provided by the expert.

    As a supplement, you can refer to this post.


    Best regards,

    Percy Tang

    0 comments No comments