SQL Server Stored Procedure Snap
Hello,
SQL Server Stored Procedure snap has 2 outputs, one for output parameters and another for result set. I am only interested in the resultset, how do I make sure the “output parameter” view is...
Forum Discussion
I already set to Validate & Execute (See first question’s images).
I added ticks to all the boxes above and correctly received a success message. However no output to the hardcoded value.
For e.g. (Server down, so not the actual mapper snap at the moment)
No output is produced provided the required field name to Get Employee. Once again, I have followed steps in tutorials precisely.
@Raph Just to validate, run your pipeline, once it’s completed check the no of document from output view of Soap execute snap from runtime log. If no of document count is 1 , which means you got a response from server, if any error comes either pipeline throw error or it will go to error view.
You click on user setting whether auto validation is checked or not, to get the response during pipeline validation time.
