https://community.qlik.com/t5/Talend-Studio/How-to-pass-Context-variable-to-tMSSQLSp/m-p/2375141#M137618 Here is a screenshot of my job. <BR /> <BR /> <BR /> <span class="lia-inline-image-display-wrapper" image-alt="0683p000009MGdL.png"><img src="https://community.qlik.com/t5/image/serverpage/image-id/132191iF0BC4A495468C444/image-size/large?v=v2&amp;px=999" role="button" title="0683p000009MGdL.png" alt="0683p000009MGdL.png" /></span> Tue, 11 Aug 2015 22:50:35 GMT Anonymous 2015-08-11T22:50:35Z https://community.qlik.com/t5/Talend-Studio/How-to-pass-Context-variable-to-tMSSQLSp/m-p/2375140#M137617 <P>Hi,<BR />&nbsp; &nbsp; 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?</P> Tue, 11 Aug 2015 22:48:59 GMT https://community.qlik.com/t5/Talend-Studio/How-to-pass-Context-variable-to-tMSSQLSp/m-p/2375140#M137617 Anonymous 2015-08-11T22:48:59Z https://community.qlik.com/t5/Talend-Studio/How-to-pass-Context-variable-to-tMSSQLSp/m-p/2375141#M137618 Here is a screenshot of my job. <BR /> <BR /> <BR /> <span class="lia-inline-image-display-wrapper" image-alt="0683p000009MGdL.png"><img src="https://community.qlik.com/t5/image/serverpage/image-id/132191iF0BC4A495468C444/image-size/large?v=v2&amp;px=999" role="button" title="0683p000009MGdL.png" alt="0683p000009MGdL.png" /></span> Tue, 11 Aug 2015 22:50:35 GMT https://community.qlik.com/t5/Talend-Studio/How-to-pass-Context-variable-to-tMSSQLSp/m-p/2375141#M137618 Anonymous 2015-08-11T22:50:35Z