locked
Want to See more Information in about Data Factory RRS feed

  • Question

  • Hello Everyone,

    I have created some pipelines in Data Factory. There are some activity which executes SQL Stored Procedure and gives output in SQL Table. How can I get the same information here which I get in SSMS Message Pane (like:- 10 rows effected), so I can know the changes done by an Executed Procedure.

    Is it possible to get this information in Azure Data Factory Portal.

    Thanks,

    Akash

    Wednesday, March 8, 2017 8:12 AM

All replies

  • Hi,

    Unfortunately, you can't see SP result in ADF. However, you can implement next logic inside your SP - create a custom log table and store SP result into it with some additional information like start/finish time. After that you can just check this table.

    BR,

    Sergiy


    Sergiy Lunyakin (Data Platfrom MVP)

    Thursday, March 9, 2017 5:42 PM