CODEWITHSUNDEEP
azure-data-factory
Gagan
Gagan

Reputation: 1923

How to save Data factory stored procedure output

Whenever I execute a stored procedure in the ADFv2, it gives me an output as 

{
    "effectiveIntegrationRuntime": "DefaultIntegrationRuntime (Australia Southeast)",
    "executionDuration": 34 
}

even though I have set 2 variables as output in the procedure. Is there any way to map the output of the stored procedure in the ADFv2? Till now I can map the output of all the other activities but not of Stored procedures.

Upvotes: 5

Views: 11664

Answers (2)

Suraj Somani
Suraj Somani

Reputation: 41

Stored procedure call in Data factory (v2) does not capture the result data set. So you cannot use the stored procedure activity to get the result data set and refer it in next activities. Workaround is to use lookup activity to call exact same stored procedure as lookup will get you the result data set from stored procedure. Replace your Stored procedure activity with lookup and it will work.

Upvotes: 4

Fang Liu
Fang Liu

Reputation: 2361

You could use a lookup activity to get the result. Please reference this post. https://social.msdn.microsoft.com/Forums/azure/en-US/82e84ec4-fc40-4bd3-b6d5-b742f3cd1a33/adf-v2-how-to-check-if-stored-procedure-output-is-empty?forum=AzureDataFactory

Update by Gagan: Instead of getting the output of SP (which is not possible in ADFv2 right now), I stored the output in the table and then apply lookup-foreach to the table to get the value.

Upvotes: 3

Related Questions