How to capture/log source & target rowCount in Azure Data Factory Pipelines

Question

Hi Team
I've created a Azure Data Factory pipeline which copies data from csv to Azure Sql db. I've configured the custom loggings. I've one piplelines with data flow task. And another Execute pipelines which executes the inner data flow task or the 1st pipeline. I've configured the custom log capture through stored procedure on top of the Execute pipeline. Now the logs are working fine but I want to capture the source and target rows i.e. rowcount in my log table. I tried with @activity('ExecutePiepline1').output.rowsCopied but it didn't work says the property doesn't exist. Kindly help me with correct expression.

Kind regards,
Mohammed

Answer 1

@Synergy Thanks for using Microsoft Q&A !!
Unfortunately, Execute pipeline Activity cannot return any output other than the Pipeline's name and Run Id of the executed pipeline. This feature request has already been shared on Uservoice and under review by the products team which you can upvote.

----------

Please do not forget to "Accept the answer" wherever the information provided helps you to help others in the community.