En el siguiente video te muestro como solucionar el error provocado al intentar cargar un archivo de datos a una base de datos de SQL Server.
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=16.0.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91' or one of its dependencies. The system cannot find the file specified. (DTSWizard)