Where does the hadron compiler/BimlStudio look for ddl files?
I am trying to implement a CI flow in Devops, and there I use bimlstudio to build a project. This works all fine, until the compiler has to deal with ScriptComponents that I have included. Then it cannot find:
Metadata file 'Microsoft.SqlServer.TxScript
Metadata file 'Microsoft.SqlServer.DTSRuntimeWrap
Metadata file 'Microsoft.SqlServer.DTSPipelineWrap
Metadata file 'Microsoft.SqlServer.PipelineHost
Which makes sense, as they are used in the Script Component.
I have tried installing Microsoft.SqlServer.IntegrationServices.Build with NuGet, but I am at a loss as to where the hadron compiler/BimlStudio expects to find these files? Does anyone know? Or does anyone know another way to make it work?
(I use the windows-latest image on Devops, as hosted agent, which has VS2019 installed).
Note: The project builds fine on a local maschine.
Thanks in advance