How to declare variable in stored procedure activity in adf

Question

Hello, I'm trying to insert error message from any activity to SQL table (sno, pipelinename, errormessage) by using parameters with Stored procedure
But generated error message is not inserting in SQL table because not having ' ' (single cotations)
Some one said me declare variable for that column
Now i don't know how to declare variable for stored procedure activity while calling Stored procedure activity

Please answer me

Answer 1

Hello @Data Engineer

You can pass a variable to a stored procedure by clicking New under the Stored Procedure Parameter option of the stored procedure activity, there you can pass variable name, it's data type and value

In your case, the value should be the error message of the activity you are using

For ex, if you are using a Copy activity with name Copy_Data then your value would be

@activity('CopyData').output.errors[0].Message