Use context variable as input parameter for tMSSqlSP

[Anonymous]

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?

[alevy]

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

[Anonymous]

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

[Anonymous]

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

[alevy]

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.