Using SQL Server Stored Procedure Snap with Parameters

Question

Using the execute snap to call a stored proc seems to be working.
Using the actual SQL Stored procedure snap does not.  It doesn’t error.  But it doesn’t run either.  Ideas?

del · Answer

First, change the Snap Execution to Validate and Execute.  Then retry the validate.
If you run into an error with the parameters, try removing the single quotes from the FM_ORACLE11_JTF parm.  You do not need to quote string values in the parameter field with the expression button toggled off.

fmdf · Answer

Thanks for the idea. It still isn’t executing. It shows GREEN after I run, but the log files in SQL are not showing that it executes.

del · Answer

It still sounds to me like the Snap execution option is incorrectly set:

That may not be the case here, but it brings up this thought for anyone that hasn’t experienced it yet:
When you change the Snap Execution to Validate &amp; Execute, on a snap that defaults to Execute, then you later use the right-click context menu to disable the snap, then later the same menu to enable the snap, the snap reverts back to its default setting of Execute instead of the Validate &amp; Execute setting you last saved.  So, each time this occurs, you have to edit the snap once more to get back to the Validate &amp; Execute setting.

Forum Discussion

Using SQL Server Stored Procedure Snap with Parameters

Recent Discussions

Ingesting Data into Veeva Vault CRM via SnapLogic – Alternatives to SFDC Snaps

SFTP: Worked ok then settings changed not not working

SQS Consumer snap is ready all message at pipeline startup

Salesforce Update REST API Throughput

Using Windows Authentication with SQL Server Accounts