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!