CODEWITHSUNDEEP
sql-serverssisssmssql-import-wizard
Ceaser
Ceaser

Reputation: 21

An error occured which the SQL Server Integration Services Wizard was not preparted to handle

I wanted to import some Excel data but when I open the SQL Server 2022 Import and Export Data (64bit). I get the below error. I am using SSMS 19.3 and Microsoft SQL Server 2022 (RTM) - 16.0.1000.6 (X64). Does Express support SSIS or need to download Dev Server

An error occurred which the SQL Server Integration Services Wizard was not prepared to handle. (SQL Server Import and Export Wizard)

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)

I browsed through various you tube videos and articles where I get suggestion to install developer edition server to solve the problem. Is there any other ways I can run the SQL Server import and export wizard to import the Excel data

Upvotes: 2

Views: 883

Answers (1)

JR Skrandel
JR Skrandel

Reputation: 1

I don't believe this feature is available for SQL Express, but for people receiving this error on a SQL (DEV, Standard or Enterprise) servers make sure SQL Server Integration Services is Installed.

Install SQL Server Integration Services Run the SQL Server Installation Center again Under Installation, Click "New SQL Server standalone Installation or add Feature to an existing installation" I was adding the feature to an instance Select add Feature to an existing.... At Feature Selection Check "Integration Services" Next, Defaults, Install Installed Access Database Engine Components redistributed 2016 x64 for excel imports.

Upvotes: 0

Related Questions