The 'Query' and the 'InputFile' options are mutually exclusive. when using Azure SQL Database Deployment task

Question

I am working with the Azure SQL Database Deployment task SqlAzureDacpacDeployment@1 in Azure DevOps and getting the below error:

##[error]The 'Query' and the 'InputFile' options are mutually exclusive.

I am not using the -Query flag in the configuration, so why am I getting this error?

Answer 1

I was passing in both additionalArguments: AND sqlAdditionalArguments: to the DevOps task - the mutual exclusivity is on these parameters on the task.

After consolidating my parameters into one of these, my deployment task now works.