question

CC-8522 avatar image
0 Votes"
CC-8522 asked CC-8522 answered

Microsoft.SQLServer.ManagedDTS reference missing

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:

109110-image.png

This is all I have in GAC_MSIL:
109163-image.png


sql-server-general
image.png (148.7 KiB)
image.png (31.8 KiB)
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

CC-8522 avatar image
0 Votes"
CC-8522 answered

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.

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Cathyji-msft avatar image
0 Votes"
Cathyji-msft answered Cathyji-msft edited

Hi @CC-8522,

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.

109227-screenshot-2021-06-25-145616.jpg

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.



5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

CC-8522 avatar image
0 Votes"
CC-8522 answered

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

109442-image.png


...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:

109328-image.png



image.png (23.9 KiB)
image.png (31.8 KiB)
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Cathyji-msft avatar image
0 Votes"
Cathyji-msft answered

Hi @CC-8522,

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


5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.