You’re offline. This is a read only version of the page.
Announcements
Hello,
I have a flow that just inserts a row to SQL. All the flow needs to do is just get the information to SQL and the table trigger handles everything else. Since adding the triggers I have received this error:
Microsoft SQL: The target table ‘My_Table’ of the DML statement cannot have any enabled triggers if the statement contains an OUTPUT clause without INTO clause.
inner exception: Microsoft SQL: The target table My_Table’ of the DML statement cannot have any enabled triggers if the statement contains an OUTPUT clause without INTO clause.
clientRequestId: 2c06cf9e-84ea-46ad-b750-fcbbc94f6ad8
Can anyone help me remedy this??
Thanks!
Hi @Anonymous
A limitation of the SQL Server connector is that it doesn't support tables with triggers.
As the documentation here states, a workaround is to use a stored procedure instead.
https://docs.microsoft.com/en-us/connectors/sql/
Share
Report
All responses (
Answers (
36,383
