Stored Procedure Activity procedure parameter with int data type in Azure Data Factory

Question

I am working on a stored procedure activity to load data into one of my table. The procedure expects an int parameter to be passed and the value for this comes from the lookup output firstrow field. But when I pass the lookup output value for the parameter the pipeline is not getting executed. I have tried to convert the values as well and even used a variable to store. Any option to process the same?

Regards, Sandeep

Answer 1

Can you send the detailed error when you try to execute the pipeline?

Thanks,

Pratik