topic tMSSqlSP Passing Parameter in Talend Studio

tMSSqlSP Passing Parameter

Anonymous — Sat, 16 Nov 2024 13:37:10 GMT

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!

Re: tMSSqlSP Passing Parameter

Anonymous — Tue, 19 Jan 2010 12:17:59 GMT

:cool:

Re: tMSSqlSP Passing Parameter

Anonymous — Thu, 25 Feb 2010 01:29:44 GMT

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!

Re: tMSSqlSP Passing Parameter

Anonymous — Thu, 25 Feb 2010 02:31:01 GMT

Hello
I have replied you on 10047.
Best regards
shong