Hello,
I am trying to pass a simple parameter using component tMSSqlSP.
Here's exactly what I type in the "SP Name"
"usp_UpdateStatus 'PASS'"
Error Message - "Incorrect syntax near ')'
I tested usp_UpdateStatus 'PASS' works, so I am not sure if SP Name takes a different syntax.
Your help is appreciated!
Hello,
Can someone provide me example or screenshot of how to pass parameters to tMSSqlSP?
I have context variables that I would like to pass to, but not sure where to place them when calling the SPROC.
Your help is appreciated!