[BUG]: sqlpackage not found on a Linux self hosted agent

[vanmash]

New issue checklist

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

Task name

SqlAzureDacpacDeploymentV1

Task version

V1

Issue Description

A bug happened!

[error]No agent found in pool Default satisfies both of the following demands: agent.os, sqlpackage. All demands: agent.os -equals Linux, sqlpackage, Agent.Version -gtVersion 2.164.1

my note: might be connected to https://github.com/microsoft/azure-pipelines-tasks/issues/18913

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

• [X] 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

Ubuntu 20.4

Relevant log output

##[error]No agent found in pool Default satisfies both of the following demands: agent.os, sqlpackage. All demands: agent.os -equals Linux, sqlpackage, Agent.Version -gtVersion 2.164.1

Full task logs with system.debug enabled

 [REPLACE THIS WITH YOUR INFORMATION] 

Repro steps

- task: SqlAzureDacpacDeployment@1
                  retryCountOnTaskFailure: 1
                  inputs:
                    azureSubscription: $(servicePrincipal)
                    AuthenticationType: 'servicePrincipal'
                    ServerName: 'sql-$(TF_VAR_PRODUCT)-$(TF_VAR_ENV).database.windows.net'
                    DatabaseName: 'sqldb-$(TF_VAR_PRODUCT)-$(TF_VAR_ENV)'
                    deployType: 'InlineSqlTask'
                    SqlInline: |
                      <SQL script>
                    IpDetectionMethod: 'AutoDetect'

[Roman-Konstantinov]

Hello @vanmash,

Did you find the solution for the issue?

[vanmash]

Hey @Roman-Konstantinov thank you for asking. We sticked to the Win agents for now.