SQL Server Import / Export Wizard Error

 Today, after having to reformat my devbox, I installed MS SQL Server.

Unfortunately, when I started the “Import/Export Wizzard,” I was greeted with this error.

===================================
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)
-----------------------------------
Program Location:
   at Microsoft.SqlServer.Dts.DtsWizard.DTSWizardForm.GetPageSize()
   at Microsoft.SqlServer.Management.UI.WizardForm.OnLoad
                                                   (EventArgs args)
   at System.Windows.Forms.Form.OnCreateControl()
   at System.Windows.Forms.Control.CreateControl
                                           (Boolean fIgnoreVisible)
   at System.Windows.Forms.Control.CreateControl()
   at System.Windows.Forms.Control.WmShowWindow(Message& m)
   at System.Windows.Forms.Control.WndProc(Message& m)
   at System.Windows.Forms.Form.WmShowWindow(Message& m)
   at System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, 
                                                 Int32 msg, 
                                                 IntPtr wparam, 
                                                 IntPtr lparam)

Searching online, I found in this post that installing the KB5027505 (Cumulative Update 6 for SQL Server) fixes the issue.

I also noted that there is a Cumulative Update 8 for SQL Server. So, I installed it too.

Comments