tMSSqlSP Passing Parameter

One Star

tMSSqlSP Passing Parameter

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!
One Star

Re: tMSSqlSP Passing Parameter

:cool:
One Star

Re: tMSSqlSP Passing Parameter

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!
Community Manager

Re: tMSSqlSP Passing Parameter

Hello
I have replied you on 10047.
Best regards
shong
----------------------------------------------------------
Talend | Data Agility for Modern Business