[BUG]: SqlAzureDacpacDeploymentV1 Drift Report output Path is not supported

[JFolberth]

New issue checklist

• I searched for existing GitHub issues
• I read pipeline troubleshooting guide
• I checked how to collect logs

Task name

SqlAzureDacpacDeployment

Task version

V1

Issue Description

Line 125 has the Output Path hard coded. This makes it impossible to pass in the Output path for the drift report as Powershell will error with Duplicate 'OutputPath' argument. In the meantime it looks like it is written to an ADO variable $SqlDeploymentOutputFile which could be use to copy to a new location.

azure-pipelines-tasks/Tasks/SqlAzureDacpacDeploymentV1
/SqlAzureActions.ps1

Environment type (Please select at least one enviroment where you face this issue)

• Self-Hosted
• Microsoft Hosted
• VMSS Pool
• Container

Azure DevOps Server type

dev.azure.com (formerly visualstudio.com)

Azure DevOps Server Version (if applicable)

No response

Operation system

Windows

Relevant log output

Duplicate 'OutputPath' argument.

Full task logs with system.debug enabled

 [REPLACE THIS WITH YOUR INFORMATION] 

Repro steps

[JFolberth]

Adding on this one cannot output multiple files as running a deploy and a drift report causes the files to be overwritten. As a workaround I am creating the deploy report, copy the results to another folder, run the drift report, copy results and then publish the entire folder.