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.
As a result of the ‘Full Load’ activity being de-activated, the Stored Procedure ‘Log Process Throughput’ is failing with the following error:
The setting for the stored procedure is as follows:
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:
>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