Share via

Issue in Procedure SQL Sever

Rohit Kulkarni 731 Reputation points
2021-12-12T16:21:34.967+00:00

Hello All,

I am executing the procedure in SQL server via Azure data factory.:

156935-image.png

But I am getting an error :

156868-image.png

Please advise.

Regards
RK

Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
0 comments
Answer accepted by question author
  1. ShaikMaheer-MSFT 38,631 Reputation points Microsoft Employee Moderator
    2021-12-13T13:47:52.003+00:00

    Hi @Rohit Kulkarni ,

    Thank you for posting query in Microsoft Q&A Platform.

    It seems you are suing Lookup activity to run your procedure.

    Lookup activity always excepts some results to be return as data from SQL. If your SQL stored procedure doesn't return any data then you may end up seeing this error.

    Kindly try to use below code as your query inside lookup if your stored procedure not returning any data and see. 

    exec dbo.proc_servicelocation_mapping  
select '1'

    Hope this will help. Please let us know if any further queries. Thank you.

    --------------

    Please consider hitting Accept Answer button. Accepted answers helps community as well.

1 additional answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Nasreen Akter 10,891 Reputation points Volunteer Moderator
    2021-12-12T16:26:42.507+00:00

    Hi @Rohit Kulkarni ,

    Would you please use the Stored Procedure option instead of Query and try again. Thanks!

Your answer

Answers can be marked as 'Accepted' by the question author and 'Recommended' by moderators, which helps users know the answer solved the author's problem.