question

Synergy-1041 avatar image
0 Votes"
Synergy-1041 asked SaurabhSharma-msft commented

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

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

azure-data-factory
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

1 Answer

SaurabhSharma-msft avatar image
1 Vote"
SaurabhSharma-msft answered SaurabhSharma-msft commented

@synergy-1041 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.

· 2
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

@synergy-1041 Please let me know if you find above reply useful. If yes, do click on 'Mark as answer' link in above reply. This will help other community members facing similar query to refer to this solution. Thanks.

0 Votes 0 ·

@synergy-1041 I have not heard back from you. Did my answer solve your issue? If so, please mark as accepted answer. If not, please let me know how I may better assist.

0 Votes 0 ·