microsoft / microsoft/sqlmanagementobjects
Failed to load assembly Microsoft.SqlServer.Management.IntegrationServicesEnum.dll
Nobody has claimed this yet.
- Dominant language
- C#
- Stars
- 143
- Forks
- 28
- PR merge metrics
- No merged PRs in 30d
Description
This is a repost of the issue I first posted https://github.com/actions/runner-images/discussions/10171
I'm having an issue with an application deployed from Azure DevOps to a Windows Server 2019 machine.
Turns out the Build Pipeline isn't copying all the Assemblies from sqlserver.smo.2016.13.0.0.2.nupkg after the NuGet Restore option.
When deployed the artefacts are missing just the one Assembly from the original NuGet Package.
Hence the error,
The log shows :
https://pkgs.dev.azure.com/{Organisation}/05dc77d4-afba-4f3c-ba2d-c5898a402225/_packaging/d33f9d5a-f68c-4a5c-9958-f326ebb73865/nuget/v3/flat2/sqlserver.smo.2016/13.0.0.2/sqlserver.smo.2016.13.0.0.2.nupkg
GET https://api.nuget.org/v3-flatcontainer/sqlserver.smo.2016/13.0.0.2/sqlserver.smo.2016.13.0.0.2.nupkg
Acquiring lock for the installation of SQLServer.SMO.2016 13.0.0.2
Acquired lock for the installation of SQLServer.SMO.2016 13.0.0.2
Installing SQLServer.SMO.2016 13.0.0.2.
Completed installation of SQLServer.SMO.2016 13.0.0.2
Adding package 'SQLServer.SMO.2016.13.0.0.2' to folder 'D:\a\1\s\packages'
Added package 'SQLServer.SMO.2016.13.0.0.2' to folder 'D:\a\1\s\packages'
Added package 'SQLServer.SMO.2016.13.0.0.2' to folder 'D:\a\1\s\packages' from source 'https://api.nuget.org/v3/index.json'
However just one Assembly is missing and that is : Microsoft.SqlServer.Management.IntegrationServicesEnum.dll
The Packages.Config references the NuGet Package :
[package id="SQLServer.SMO.2016" version="13.0.0.2" targetFramework="net472" /]
The same issue occurs when building the project in Visual Studio 2019 and 2022
I have added an Installer Project and when that is built. the one file missing is the same Microsoft.SqlServer.Management.IntegrationServicesEnum.dll
Contributor guide
No contributing guide indexed for this repository
First steps
- Read the whole issue, then the project's contributing guide.
- Comment on the issue to say you are picking it up — it saves two people doing the same work.
- Fork the repository and make your change on a branch.
- Open a pull request that references the issue number.
Research direction
Start by inspecting SQLServer.SMO.2016.13.0.0.2.nupkg and reproducing the restore/build in Visual Studio 2019 or 2022. Compare the package contents with the deployed artifacts, focusing on Microsoft.SqlServer.Management.IntegrationServicesEnum.dll; done means the assembly is consistently present after build and deployment.
Written by the indexing model from the issue text.
Assessment
- Tech stack
- csharp
- Domain
- build-system, databases
- Issue type
- Bug
- Difficulty
- 3/5
- Estimated time
- 1-2 days
- Activity status
- Stale
- Clarity
- Needs clarification
- Newbie friendliness
- 25/100