How to fix Could not load type 'DTSTransform.SCD.6' from assembly 'Microsoft.SqlServer.PipelineHost, Version=14.0.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91'

Bill LaLonde 30 Reputation points
2023-01-24T16:31:24.3833333+00:00

I'm trying to run an Integration Services Assessment using the Data Migration Assessment tool, however, when selecting the folder containing my .dtsx packages. The assessment runs mostly fine, but I am getting this error:

The managed pipeline component "DTSTransform.SCD.6" could not be loaded.  The exception was: Could not load type 'DTSTransform.SCD.6' from assembly 'Microsoft.SqlServer.PipelineHost, Version=14.0.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91'

I do have the DLL file in Version 14.0.0.0; however, the error is suggesting otherwise. I checked Services.msc and SQL Server Integration Services is running.

VS 2019 Community Edition

Microsoft® Data Migration Assistant v5.7

Azure Database Migration service
SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,577 questions
SQL Server Migration Assistant
SQL Server Migration Assistant
A Microsoft tool designed to automate database migration to SQL Server from Access, DB2, MySQL, Oracle, and SAP ASE.
532 questions

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Aicha Diakité 0 Reputation points
    2023-01-26T05:54:03.9466667+00:00

    Hi ,

    Did you manage to fix your issue ?

    I'm having the same kind of error in my package :

    Impossible de charger le composant de pipeline managé « AttunitySSISODBCSrc.8 ». L'exception était : Impossible de charger le type 'AttunitySSISODBCSrc.8' à partir de l'assembly 'Microsoft.SqlServer.PipelineHost, Version=14.0.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91'..

    It's fine when running on VS but does not work when deployed on sql server

    Regards

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.