Forum Discussion
ADF Lookup Stored Procedure Error
I have a stored procedure that has the following format: If (@x = 1) BEGIN RETURN SCOPE_IDENTITY() END ELSE BEGIN RETURN COLUMN1 END I'm using a Lookup in ADF and it gives me an...
I created a new procedure that has an OUTPUT parameter.
SET @ReturnID = SCOPE_IDENTITY()
I'm still getting the same error on the lookup.
The specified Stored Procedure is not valid. It could be caused by that the stored procedure doesn't return any data.
SET @ReturnID = SCOPE_IDENTITY()
I'm still getting the same error on the lookup.
The specified Stored Procedure is not valid. It could be caused by that the stored procedure doesn't return any data.