Hi Nikhil , Welcome to MS Q&A
I think docs are not attached so it is not clear why your copy activity is running twice in a loop in Azure Data Factory. However, you can monitor the Copy activity run in Azure Data Factory and Synapse pipelines both visually and programmatically to understand the issue better.
Here are some useful references to help you monitor and optimize your Copy activity:
- Monitor copy activity: This guide shows you how to collect the run result and performance statistics in the copy activity monitoring view.
- Copy activity in Azure Data Factory and Azure Synapse Analytics: This guide describes key factors that affect the performance of data movement via the Copy activity and how to optimize it.
Please check this if it helps , or else share the docs with steps to troubleshoot further
Looking forwards to hear from you
Thanks
Deepanshu