Microsoft.SQLServer.ManagedDTS reference missing

Question

I've pulled down a solution from Team Foundation Server developed by team member.
I am missing references for:
Microsoft.SQLServer.ManagedDTS
Microsoft.SqlServer.Management.IntegrationServices

I have SSIS on my machine along with Reporting Services.

If I go to Visual Studios >> top 'Tools' menu >> Get Tools and Features
Looks like I already have SQL Server Data Tools installed:

This is all I have in GAC_MSIL:

Answer 1

Re-downloaded Microsoft® SQL Server® 2019 Express
https://www.microsoft.com/en-us/Download/details.aspx?id=101064

1. Chose Custom from Installer initial popup
2. Click top right link on "SQL Server Installation Center" popup to add features to an existing installation
3. Run Setup and make sure you have needed installs.

Answer 2

Hi @CC ,

If recently installed Microsoft SQL Server (or related software), please uninstall then try reinstalling Microsoft SQL Server software to resolve the issue. If it is not work, please try the other solutions from the below blog.

Fix Microsoft.SqlServer.ManagedDTS.dll DLL Errors and Download Now

Answer 3

If I look in C:\Program Files (x86)\Microsoft SQL Server directory and all its folders,

...there are no 'SDK/Assemblies' paths.
I also searched for the .dll file in this directory and nothing came up.

For the GAC_MSIL, this is all I have:

Answer 4

Hi @CC ,

Quote from the old thread missing Microsoft.SqlServer.ManagedDTS.

In the Add Reference dialog window, click on the browse tab. Then navigate your way to:

C:\Program Files\Microsoft SQL Server\90\SDK\Assemblies

There you will find the Microsoft.SQLServer.ManagedDTS.dll, select it and hit okay.

For Microsoft.SqlServer.Management.IntegrationServices, we can get this once we installed SSIS. Please check you have installed SSIS from SQL server configuration manager. Below is the test that I check today, once I add the SSIS feature in SQL 2019 instance in my environment, I get this file.

By the way, what is the version of your SQL server.

---

If the response is helpful, please click "Accept Answer" and upvote it, as this could help other community members looking for similar queries.