Azure-pipelines-tasks: `Azure SQL Database deployment` task continues when there is an error if you pass the `--verbose` argument

[ChristopherHaws]

Required Information

Question, Bug, or Feature?
Type: Bug
Enter Task Name: Azure SQL Database deployment

Environment

• Server - Azure Pipelines
• Agent - Hosted and Private

Issue Description

Azure SQL Database deployment task continues when there is an error if you pass the --verbose argument in the Additional Invoke-Sqlcmd Arguments field.

[chperich]

Thanks for reporting this issue. We are able to repro this on our end. We will roll out a fix shortly.

[SumiranAgg]

We have merged the fix. The fix will be rolled out in next sprint. If this is blocking issue, follow below steps to upload task manually to your account:

1. clone repo to local
2. execute below commands in cmd
   npm install -g tfx-cli
   node c:/azure-pipelines-tasks/make.js build test --task SqlAzureDacpacDeploymentV1
   tfx login --service-url "" --token
   tfx build tasks upload --task-path