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,407 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.
474 questions
{count} vote

1 answer

Sort by: Most helpful
  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