SQL Import and export wizard is not working

Francis AT 20 Reputation points
2023-11-24T15:09:39.45+00:00

Hello,

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.


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


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
    2023-11-26T12:13:54.1866667+00:00

    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.

    https://learn.microsoft.com/en-us/sql/integration-services/integration-services-features-supported-by-the-editions-of-sql-server?view=sql-server-ver16

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

    https://learn.microsoft.com/en-us/sql/integration-services/install-windows/install-integration-services?view=sql-server-ver16

    https://www.mssqltips.com/sqlservertip/6635/install-ssis/

    Hope this helps

    0 comments No comments

  2. PercyTang-MSFT 12,426 Reputation points Microsoft Vendor
    2023-11-27T05:55:26.7+00:00

    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.

    https://techcommunity.microsoft.com/t5/sql-server/error-with-my-sql-server-2022-preview-import-and-export-wizard/m-p/3585487

    Best regards,

    Percy Tang

    0 comments No comments