I've only been at Data Factory for a short while and so far, looks OK. But I could hardly believe it when I found (apparently) that I cannot get at the result set of a SQL Server stored procedure. Is this really true? It looks like I might have to execute that stored procedure and get it to put the output into a (permanent!) table which I can read. Crazy?
Yes, this is by design, you cannot view the actual output of the stored procedure results, instead you just see the activity execution results.
You can add your points to support this similar idea already logged here Logging support for Store Procedure Pipeline