Finding a SQL Server Assembly: Where is "100" folder in the installation folder in SQL Server 2019

All we need is an easy explanation of the problem, so here it is.

I need this assembly Microsoft.SqlServer.RuntimeWrapper.dll and it is not in <drive>:\Windows\Microsoft.NET\assembly. I have SQL Server 2019 installed (Developer Edition).
According to this page link the assemblies should also be in this folder: <drive>:\Program Files\Microsoft SQL Server\100\SDK\Assemblies. But on my computer I do not have the 100 folder. There are 80, 90, 110, 130, 150, Client SDK and MSSQL15.MSSQLSERVER. I think I have checked the relevant boxes when choosing features.

How can I get hold of Microsoft.SqlServer.RuntimeWrapper.dll?

Thanks.

Edit: Both of these PowerShell searches to not give any hits. I have also tried these searched on production servers with SQL Server and Integration Services installed and no hits:

Get-ChildItem "$env:SystemRoot\Microsoft.NET\"  -Filter *RuntimeWrapper.dll -Recurse -Force -ErrorAction Ignore
Get-ChildItem "C:\Program Files\Microsoft SQL Server\" -Filter *Wrapper.dll -Recurse -Force -ErrorAction Ignore

Edit: On my SQL Server installation the following are installed:
Finding a SQL Server Assembly: Where is "100" folder in the installation folder in SQL Server 2019

Extention for SSIS:

Finding a SQL Server Assembly: Where is "100" folder in the installation folder in SQL Server 2019

How to solve :

I know you bored from this bug, So we are here to help you! Take a deep breath and look at the explanation of your problem. We have many solutions to this problem, But we recommend you to use the first method because it is tested & true method that will 100% work for you.

Method 1

I think that’s a doc issue. That’s the Primary Interop Assembly, so it’s not really part of SSIS. And it’s installed as part of the Visual Studio tools.

C:\Program Files (x86)\Microsoft Visual Studio\2019\Enterprise\Common7\IDE\CommonExtensions\Microsoft\SSIS\150\Binn\Microsoft.SqlServer.DTSRuntimeWrap.dll

Note: Use and implement method 1 because this method fully tested our system.
Thank you 🙂

All methods was sourced from stackoverflow.com or stackexchange.com, is licensed under cc by-sa 2.5, cc by-sa 3.0 and cc by-sa 4.0

Leave a Reply