Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

Where can I get Microsoft.SqlServer.ManagedDTS version 15?

I have an SSIS project (dtproj) that opens fine in VS 2017 and I am trying to open it in Visual Studio 2019. I installed the "SQL Server Integration Services Projects" extension and have SSDT installed also. When I open the solution it tells me the project is incompatible. If I reload the project I get a message that says, Could not load file or assembly 'Microsoft.SqlServer.ManagedDTS, Version 15.0.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91' or one of its dependencies. The system cannot find the file specified.

It makes sense because when I look in C:\Windows\Microsoft.NET\assembly\GAC_MSIL\Microsoft.SqlServer.ManagedDTS I have versions 11, 12, 13, and 14. But not 15. What do I need to install to get version 15?

like image 702
nickfinity Avatar asked Jan 19 '21 16:01

nickfinity


People also ask

Where is Microsoft SqlServer ManagedDTS DLL located?

Step1--> Run --> type C:\Windows\assembly\gac_msil. You will find a folder like Microsoft. SqlServer. ManagedDTS.

What is Microsoft SqlServer DTS runtime?

The Microsoft. SqlServer. Dts. Runtime namespace contains the classes and interfaces to create packages, custom tasks, and other package control flow elements.


1 Answers

Hopefully this will be helpful for others. I fixed this error by installing the SQL Server Data Tools (SSDT) for Visual Studio 2017, since it contains the Version 15 of ManagedDTS:

https://docs.microsoft.com/en-us/sql/ssdt/previous-releases-of-sql-server-data-tools-ssdt-and-ssdt-bi?view=sql-server-2017#ssdt-for-visual-studio-vs-2017

I then restarted Visual Studio 2019 and opened the SSIS project fine.

like image 147
Michael Hanna Avatar answered Oct 08 '22 21:10

Michael Hanna