[BUG] DeployScript and DeployReport Task Options Not Used

[ksullivan1856]

Component

• PublishDacPac
• DeployDatabase

Describe the bug
When using the DeployScriptPath and/or DeployReportPath task options, they are not honored during task execution.
See this line in the PublishDacPacTask:

AzureDevOpsExtensionsForSqlServer/extensions/PublishDacPac/PublishDacPacTask/PublishDacPacTask.ps1

Line 91 in 83c6e88

if ("$DeployScriptPath" -ne "") {

Variable: $DeployScriptPath or $DeployReportPath is never assigned at the beginning of the task where all the task inputs are collected, starting at:

AzureDevOpsExtensionsForSqlServer/extensions/PublishDacPac/PublishDacPacTask/PublishDacPacTask.ps1

Line 24 in 83c6e88

[string]$DacPacPath = Get-VstsInput -Name "DacPacPath" -Require;

To Reproduce
Run PublishDacPacTask with DeployScriptPath and DeployReportPath populated (not empty). The result will be an actual publish action to the target database rather than creating a deployment script.

Expected behavior
When DeployScriptPath is not an empty string, a publish script should be created, the database should NOT be updated.

Screenshots

Azure DevOps Agent
Self-Hosted Agent: Version 2.144.2