One Star

Use context variable as input parameter for tMSSqlSP

I have set a context variable in my main job and want to use it as a input parameter in my tMSSqlSP componenent. However it is not possible to use it there. How to do this?
4 REPLIES
Seven Stars

Re: Use context variable as input parameter for tMSSqlSP

Your job design looks fine to me. What problem are you having exactly?
Moderator

Re: Use context variable as input parameter for tMSSqlSP

Hi limsuser,
I have seen that you used tRunjob. Is there any child job in your job design? The tMSSqlSP is the child job in your last screenshot? Do you want to Pass a value from a parent Job to a child Job?
Best regards
Sabrina
--
Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.
One Star

Re: Use context variable as input parameter for tMSSqlSP

The problem is not that the context variables being available in my subjob, but how to pass them as input parameter to my stored procedure?
In the screenshot you can see the context variables are available, but i can't access them in my input parameter for my sp. They are NULL then
Seven Stars

Re: Use context variable as input parameter for tMSSqlSP

tMSSqlSP uses values from the incoming row as the parameters, not context variables. You should use tFixedFlowInput to put your context variables into the row for tMSSqlSP.