Support for Elastic database transactions
ADF must support Elastic database transactions towards Azure SQL Database.
This is equivalent to the on-premise scenario, where SSIS transactions use MSDTC towards SQL Server.
Currently, if you set TransactionOption=Required on a data flow, and use an OLEDB connection to an Azure SQL Database, you receive an error like:
"The SSIS runtime has failed to enlist the OLE DB connection in a distributed transaction with error 0x80070057 "The parameter is incorrect".
Mahadevan Alagar commented
Any plans of GA/Preview availability of this feature?
This is very much is required as the BASIC...
+1 for this, seems like a large oversight to not support transactions
I am also getting similar error .