Forum Discussion
Executing SQL trigger doesn't work if triggering events are generated by Azure Data Factory
Good day everyone, I have an issue getting data from Azure Data Factory into SQL. My original solution of using power automate was stymied by the combination of a mysteriously slow Stored Proced...
Your post is much to vague to give an answer on it.
But if you perform a BULK operation, then by default trigger don't fire, see
https://learn.microsoft.com/en-us/sql/t-sql/statements/bulk-insert-transact-sql?view=sql-server-ver16#fire_triggers
But if you perform a BULK operation, then by default trigger don't fire, see
https://learn.microsoft.com/en-us/sql/t-sql/statements/bulk-insert-transact-sql?view=sql-server-ver16#fire_triggers
- Does Data Factory use bulk inserts in the "Copy Data" activity? The inserts into the SQL staging table are done using "Copy Data" activity.
