2

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: enter image description here

Extention for SSIS:

enter image description here

Improve this question
6
  • 1
    Are you sure that you have installed Install Integration Services (SSIS)? This might help. learn.microsoft.com/en-us/sql/integration-services/…
    – SqlWorldWide
    Commented Mar 17, 2022 at 17:58
  • @SqlWorldWide: I tried to choose as much as possible with SSIS. Don't remember the choices now, but quite sure everything with SSIS was chosen.
    – xhr489
    Commented Mar 17, 2022 at 18:00
  • 1
    I added a link to my initial comment which might help.
    – SqlWorldWide
    Commented Mar 17, 2022 at 18:10
  • @SqlWorldWide: Please see screenshot. But it is strange that I cannot unselect features and I can only add more. Is that normal?
    – xhr489
    Commented Mar 17, 2022 at 18:54
  • 1
    "<drive>:\Program Files\Microsoft SQL Server\100\SDK\Assemblies". This path seems old. Try to look into 130 , 140 or 150 folders
    – MBuschi
    Commented Mar 18, 2022 at 8:02

1 Answer 1

Reset to default
3

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
Improve this answer
13
  • Hi, thanks. I have Visual Studio Proffesional. And it is not there. What do I need to choose in the Visual Studio Installer?
    – xhr489
    Commented Mar 18, 2022 at 12:42
  • 2
    Did you install the "SQL Server Integration Services Projects" Visual Studio Extension?
    – David Browne - Microsoft
    Commented Mar 18, 2022 at 12:48
  • Yes it is installed, see screenshot in the question.
    – xhr489
    Commented Mar 18, 2022 at 13:11
  • I am trying to uninstall the extension and install it again.
    – xhr489
    Commented Mar 18, 2022 at 13:15
  • 1
    I can load and use that from both 32bit and 64bit programs. If you're having an issue in powershell, add some sample code and the error to your question.
    – David Browne - Microsoft
    Commented Mar 20, 2022 at 18:36

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.