How can I accept and process output form stored procedure in azure data dactory ?

Question

I am trying to create a pipeline in the Azure data factory and want to process the output returned by my stored procedure.
Till now I am able to successfully connect to my stored procedure in azure SQL database.

This is the error I am getting while doing this:

@string(activity('Stored procedure1').output.firstrow.result)  

 

This is my stored procedure:

CREATE PROCEDURE [jobs].[ADF]

@Input NVARCHAR(``100``),

@Result NVARCHAR(``100``) OUTPUT

AS

BEGIN

PRINT @Input

SET @Result='DummyString'

END;

Answer 1

You need to use script activity or Lookup activity for capturing the output of stored procedure

STored procedure activity doesnt return any output values and is just to trigger an SP