This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(204.8, 13%, 29%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EVS%3C/text%3E%3C/svg%3E)
Hi,
how to set a up a audit log table in in adf pipeline.... i know single copy activity can be logged using sp for failure and success but how about multiple copy activity or any other activity failed
have tried below for single copy activity
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(99.2, 65%, 19%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ECB%3C/text%3E%3C/svg%3E)
Just checking in to see if the below answer provided by @ Nandan Hegde helped.
If this answers your query, do click Accept Answer and Yes for was this answer helpful. And, if you have any further query do let us know.
Below Blog provides detailed aspect for copy activity logging :
https://www.mssqltips.com/sqlservertip/6320/logging-azure-data-factory-pipeline-audit-data/
But in general if you want to log for all activities their failure msgs etc, plz follow the below blog to have a customized approach :
Any screenshot pls
Plz refer the blogs (they have step by step details with all images/screenshots )
reference :