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

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

首先检查 SQLServer.SMO.2016.13.0.0.2.nupkg，并在 Visual Studio 2019 或 2022 中重现 restore/build。将包内容与已部署的构件进行比较，重点关注 Microsoft.SqlServer.Management.IntegrationServicesEnum.dll；完成的标准是该程序集在构建和部署后始终存在。