Forum Discussion

IgnatiusN's avatar
IgnatiusN
New Contributor II
8 years ago

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...
IgnatiusN's avatar
IgnatiusN
New Contributor II
8 years ago

This pipeline is a sub-pipeline of an integration pipeline, and having multiple outputs causes problems.

del's avatar
del
Contributor III
8 years ago

@IgnatiusN, I used to use a Script snap (with output view removed) for this.

Python Example:

from com.snaplogic.scripting.language import ScriptHook
from com.snaplogic.scripting.language.ScriptHook import *

class MFParser(ScriptHook):
def __init__(self, input, output, error, log):
    self.input = input
    self.output = output
    self.error = error
    self.log = log

def execute(self):
    while self.input.hasNext():
        data = self.input.next()

hook = MFParser(input, output, error, log)

I have since written a custom snap that does the same thing and is slightly better in performance (when measured by milliseconds).