azure-data-factory

How to configure an Activity to continue in Azure Data Factory when an previous Activity is Deactivated


I have stored procedure activity that I would like to complete even if the previous activity is deactivated. In the image below you can see that the activity 'Full Load' is de-activated.

enter image description here

As a result of the 'Full Load' activity being de-activated, the Stored Procedure 'Log Process Throughput' is failing with the following error:

enter image description here

The setting for the stored procedure is as follows: enter image description here

I can see that the problem is with

activity('Full Load').output.rowsCopied

I need the stored procedure activity to execute even though the 'Full Load' activity is de-activated.

Can someone let me know if that is possible?

Applying @activity('Full Load')?.output?.rowsCopied

Gives the following error:

enter image description here


Solution

  • Can you try using : @activity('Full Load')?.output?.rowsCopied And you can use collasce to check whether it is null and provide value accordingly