DML statement cannot have any enabled triggers if the statement contains an OUTPUT clause without INTO clause (SQL)

Error Example:

DML statement cannot have any enabled triggers if the statement contains an OUTPUT clause without INTO clause.

Cause:

With version 9.5.6.0 a new feature has been introduced which allows synchronizing SQL blobs with the Cloud Connector. This feature required the implementation of custom SQL select statement parsing. Due to the complexity of SQL select statement parsing, this introduced some side-effects which in edge-cases can lead to errors. 

Resolution/Workaround:

As long as you don't want to synchronize SQL blobs with the affected connection, you can simply disable the custom SQL select statement parsing. Just add the following parameter to the connection string of the SQL data entity:

SqlStatementAdjustments=false;

In case this does not resolve your issue, please contact us under [e-mail] and add a support files package. You can follow the steps described here to create the package.