while trying to build dacpac using sqlpackage.exe, we are getting the following error
Microsoft.SqlServer.Dac.DacServicesException: An error occurred during deployment plan generation. Deployment cannot continue. Error SQL0: Required contributor with id 'BcDevKit.DeploymentContributors.DacMacroSqlDeploymentContributor' could not be loaded.
The above error can be fixed if I copy the contributors from
C:\Program Files (x86)\Microsoft Visual Studio\2017\Enterprise\Common7\IDE\Extensions\Microsoft\SQLDB\DAC\150\Extensions
C:\Program Files (x86)\Microsoft SQL Server\150\DAC\bin\Extensions
I want sqlpackage to search for contributors only in Visual Studio directory. Can anyone help?