Cannot create Sql Source. Please double check the connection string, stored procedure are set with correct format. Error: The value of the property 'Value' is invalid for the stored procedure parameter 'RunID'
Cannot create Sql Source. Please double check the connection string, stored procedure are set with correct format. Error: The value of the property 'Value' is invalid for the stored procedure parameter 'RunID'
Hey,
Based on the error message it seems that the RunId which you are passing as parameter to the SP activity is not properly configured.
Can you please share the code and image
![123604-1111.png][1]
This
[1]: /answers/storage/attachments/123604-1111.png
ADF Pipeline

Error

Stored Procedure

JSON Code of Lookup Activity

Parameters of Stored Procedure

Dynamic Content of RunID

Hey,
PFB the sample code:
Declare @Test varchar(255)
Set @Test= '@{pipeline().DataFactory}'
Select @Test

Add the value in quotes as Ids are Guid values and close the parameter with } .
In case if your RunId is some internal int value no need to add it in quotes, just terminate the bracket
Still Getting same Error

Error

Hey,
As suggested by Ryan, can you please add that logic in another lookup activity and check for its output?
And pass that into Stored procedure as in input parameter ?
But on a side note will suggest to just pass the @activity('lookupactivity').output.firstrow.RunId as SP paremeter and handle the if else scenario within the SP itself rather than handling it as parameter level
I'd suggest putting all that logic in to a "Lookup Activity" stored procedure (not sure if you're doing a stored procedure or select max in that activity) so that the correct ID is returned
PS what if this process is kicked off twice concurrently, they'd both end up with ID 1000?
First i have created a table and also created a stored procedure in Azure SQL Database after that created pipeline in that pipeline i added one copy activity and two stored procedures one stored procedure for if copy activity fail then it will store the details of pipeline activity, one stored procedure for if copy activity success then it will store the details of pipeline activity.
I want when first time run the pipeline the RunID column inserted with value is 1000, When Execute pipeline second time the RuID column inserted with values 1001 and whenever the pipeline executed the RunID also increase +1 of the previous RunID value.
Note:- Do not use IDENTITY() in that table
13 people are following this question.