How to fix Could not load file or assembly 'Microsoft.SqlServer.ManagedDTS, Version=14.0.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91

Question

I'm trying to run an Integration Services Assessment using the Data Migration Assessment tool, however, when selecting the folder containing my .dtsx packages I get the following error:

Could not load file or assembly 'Microsoft.SqlServer.ManagedDTS, Version=14.0.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91'

Searching the web, I found that I was in fact missing version 14 of the ManagedDTS folder. So, I downloaded SQL Server 17 Express which contains version 14 (see pic).

This issue, however, still exists even after having the necessary file/folder. Also, the solution containing the package loads fine in V

S.

VS 2019 Community Edition

Microsoft® Data Migration Assistant v5.7

Answer 1

Hi @Bill LaLonde

Please firsrt check whether we have SQL Server Integration Services installed. In order to do that, navigate to Start > Run > Services.msc > OK. Then locate the SQL Server Integration Services service and ensure it is running.

If Integration Services is not present, we have to go ahead with the installation.

Check: Install Integration Services (SSIS)

Regards，

Zoe Hui

---

If the answer is helpful, please click "Accept Answer" and upvote it.