[Question]: #21206
Description
Task name
SqlAzureDacpacDeploymentV1
Task version
1.x.x
Environment type (Please select at least one enviroment where you face this issue)
- Self-Hosted
- Microsoft Hosted
- VMSS Pool
- Container
Azure DevOps Server type
Azure DevOps Server (Please specify exact version in the textbox below)
Azure DevOps Server Version (if applicable)
Azure DevOps Server 2020 Update 1.2
Operation system
Windows Server 2016 Datacenter
Question
I can't seem to get my dacpac file to deploy because the task is using the wrong version of SqlPackage.exe. Is there a way to just simply point to the exe? The build agent has SSDT for VS 2019 and 2022. I noticed the FindSqlPackagePath.ps1 script has a bunch of logic to determine where it is based of the myriad of ways and locations it can be installed to but I don't think that covers multiple versions. Other teams use this build agent and it would be a whole lot simpler if I could just specify where it is instead of trying to make potentially breaking changes to the environment.