Azure Pipeline Deployment - Linked Server and DTC Error

EDempster

I have a database managed by SQL Source Control that is being deployed to servers using an Azure Pipeline (with code in Azure DevOps). The target database is an Azure SQL Managed Instance. Recently, I've added a stored procedure that queries another server using a linked server. With this addition, the build succeeds, but the deployment fails with the following message.

The error 'Import of Microsoft Distributed Transaction Coordinator (MS DTC) transaction failed: 0x80070057(The parameter is incorrect.).' occurred when executing the following SQL:
....

I don't receive this message when I deploy the stored procedure using SQL Compare 15 with the SQL Source Control code as the source.

Is there a flag I need to set in the pipeline task to emulate SQL Compare, not to import MSDTC?

EDempster

Sorry, this one was staring me in the face, and I didn't see it. 

Adding NoTransactions to the SQLCompareOptions in the task fixed the issue.

Jon_Kirkwood

Thanks for posting up your solution to your initial query.
Hopefully it helps someone in the future with the same error.