The question:
I need this assembly Microsoft.SqlServer.RuntimeWrapper.dll and it is not in <drive>:WindowsMicrosoft.NETassembly. I have SQL Server 2019 installed (Developer Edition).
According to this page link the assemblies should also be in this folder: <drive>:Program FilesMicrosoft SQL Server100SDKAssemblies. 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:SystemRootMicrosoft.NET" -Filter *RuntimeWrapper.dll -Recurse -Force -ErrorAction Ignore
Get-ChildItem "C:Program FilesMicrosoft SQL Server" -Filter *Wrapper.dll -Recurse -Force -ErrorAction Ignore
Edit: On my SQL Server installation the following are installed:
Extention for SSIS:
The Solutions:
Below are the methods you can try. The first solution is probably the best. Try others if the first one doesn’t work. Senior developers aren’t just copying/pasting – they read the methods carefully & apply them wisely to each case.
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 Studio2019EnterpriseCommon7IDECommonExtensionsMicrosoftSSIS150BinnMicrosoft.SqlServer.DTSRuntimeWrap.dll
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