microsoft / microsoft/sqlmanagementobjects

Failed to load assembly Microsoft.SqlServer.Management.IntegrationServicesEnum.dll

Open
#168 3 comments 0 reactions 0 assignees View on GitHub

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

  1. Read the whole issue, then the project's contributing guide.
  2. Comment on the issue to say you are picking it up — it saves two people doing the same work.
  3. Fork the repository and make your change on a branch.
  4. 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

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.