azure-pipelines-tasks: ##[error]Unable to find the location of Dac Framework (SqlPackage.exe) from registry on

Question, Bug, or Feature?
Type: Bug

Enter Task Name: SqlAzureDacpacDeployment@1

list here (V# not needed):
https://github.com/microsoft/azure-pipelines-tasks/blob/master/Tasks/SqlAzureDacpacDeploymentV1/README.md

Environment

• Server - Azure Pipelines or TFS on-premises?

  • If using TFS on-premises, provide the version:

  • If using Azure Pipelines, provide the account name, team project name, build definition name/build number:

• Agent - Private:

Issue Description

Our builds have started failing recently at dacpac deployment step. Previously all builds were running successfully and there are no changes in the build pipeline. It seems dacpac deployment component has changed. The only difference in the successful builds and failing builds is the Azure SQL Database deployment version change from 1.202.0 to 1.209.0. This is the task configuration: Is there any change expected with the new version of Azure SQL Database deployment component? And which VS version does it expects to be present in the build agent? Currently we are having Microsoft Visual Studio\2019 installed on the agents.

Task logs

"D:\a\_work\1\b\2\_work\_tasks\SqlAzureDacpacDeployment_ce85a08b-a538-4d2b-8589-1d37a9ab970f\1.209.0\vswhere.exe" -version [15.0,18.0) -latest -format json ##[error]Unable to find the location of Dac Framework (SqlPackage.exe) from registry on machine 7d8c7c86c000000Check out how to troubleshoot failures at https://aka.ms/sqlazuredeployreadme#troubleshooting- [Enable debug logging and please provide the zip file containing all the logs for a speedy resolution]

Troubleshooting

Checkout how to troubleshoot failures and collect debug logs: https://docs.microsoft.com/en-us/vsts/build-release/actions/troubleshooting

Error logs