Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Connect 2026! Turn data into bold moves, April 13 -15: Learn More!
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

How to pass Context variable to tMSSQLSp

Hi,
    I have a job that is pulling raw data from one server to another and then I would like to execute a stored procedure. All jobs and subjobs are using the context.year to run. I'm almost done but I have an issue figuring out how to pass in the context.year into the tMSSQLSP component for it to run. Searching on line, I found this example, (), but I there is no example and I don't know how to setup the link between my existing job to tFixedFlowInput to tMSSqlSP. Can someone point me in the right direction?

Labels (2)
1 Reply
Anonymous
Not applicable
Author

Here is a screenshot of my job.


0683p000009MGdL.png