<?xml version="1.0" encoding="UTF-8"?>
<rss xmlns:content="http://purl.org/rss/1.0/modules/content/" xmlns:dc="http://purl.org/dc/elements/1.1/" xmlns:rdf="http://www.w3.org/1999/02/22-rdf-syntax-ns#" xmlns:taxo="http://purl.org/rss/1.0/modules/taxonomy/" version="2.0">
  <channel>
    <title>topic Re: Using tContextLoad and tFixedFlowInput for Input Parameters to MSSqlSP in Talend Studio</title>
    <link>https://community.qlik.com/t5/Talend-Studio/Using-tContextLoad-and-tFixedFlowInput-for-Input-Parameters-to/m-p/2373069#M135833</link>
    <description>You can't use context variables in the Inline Content(delimited file) option as the contents of that box are treated as if they were being read from a delimited file (funnily enough) i.e. it's trying to put the words "context.intLogTypeId" into the first column of your schema.  Use the Single Table option instead.</description>
    <pubDate>Wed, 21 Aug 2013 15:11:18 GMT</pubDate>
    <dc:creator>alevy</dc:creator>
    <dc:date>2013-08-21T15:11:18Z</dc:date>
    <item>
      <title>Using tContextLoad and tFixedFlowInput for Input Parameters to MSSqlSP</title>
      <link>https://community.qlik.com/t5/Talend-Studio/Using-tContextLoad-and-tFixedFlowInput-for-Input-Parameters-to/m-p/2373067#M135831</link>
      <description>I have a Stored Procedure with three Input Parameters. I would like to supply values for these three parameters via tContextLoad, but I don't understand how to set the properties of the tFixedFlowInput component or the MSSqlSP component. 
&lt;BR /&gt;In the tFixedFlowInput component: 
&lt;BR /&gt;Currently I have 'Number of Rows' set to 1, the 'Use Inline Content(delimited file) option selected and in the 'Content' box I have this: 
&lt;BR /&gt;context.intLogTypeId;context.strObjectID;context.strObjectName 
&lt;BR /&gt;The schema for this component contains 3 rows, one for each of the data items shown in the 'Content' box and in the same order. 
&lt;BR /&gt;In the MSSqlSP component: 
&lt;BR /&gt;3 columns defined: 
&lt;BR /&gt;intLogTypeId IN 
&lt;BR /&gt;strObjectId IN 
&lt;BR /&gt;strObjectName IN 
&lt;BR /&gt;The job context file contains this: 
&lt;BR /&gt;intLogTypeId;1 
&lt;BR /&gt;strObjectID;objXID 
&lt;BR /&gt;strObjectName;PenXObj2 
&lt;BR /&gt;When I run the job, I get this error (it looks like it's passing a value of "context.intLogTypeId" rather than the value contained within this jobcontext item) 
&lt;BR /&gt;Starting job Proof2 at 16:40 20/08/2013. 
&lt;BR /&gt; connecting to socket on port 4010 
&lt;BR /&gt; connected 
&lt;BR /&gt;Exception in component tFixedFlowInput_1 
&lt;BR /&gt;java.lang.NumberFormatException: For input string: "context.intLogTypeId" 
&lt;BR /&gt; at java.lang.NumberFormatException.forInputString(Unknown Source) 
&lt;BR /&gt; at java.lang.Integer.parseInt(Unknown Source) 
&lt;BR /&gt; at java.lang.Integer.parseInt(Unknown Source) 
&lt;BR /&gt; at routines.system.ParserUtils.parseTo_int(ParserUtils.java:87) 
&lt;BR /&gt; at routines.system.ParserUtils.parseTo_Integer(ParserUtils.java:94) 
&lt;BR /&gt; at healthdwforiqm.proof2_0_1.Proof2.tFixedFlowInput_1Process(Proof2.java:1841) 
&lt;BR /&gt; at healthdwforiqm.proof2_0_1.Proof2.tMSSqlRow_1Process(Proof2.java:1549) 
&lt;BR /&gt; at healthdwforiqm.proof2_0_1.Proof2.tMSSqlConnection_4Process(Proof2.java:1444) 
&lt;BR /&gt; at healthdwforiqm.proof2_0_1.Proof2.tMSSqlConnection_1Process(Proof2.java:1329) 
&lt;BR /&gt; at healthdwforiqm.proof2_0_1.Proof2.tFileInputDelimited_3Process(Proof2.java:1214) 
&lt;BR /&gt; at healthdwforiqm.proof2_0_1.Proof2$1.run(Proof2.java:4144) 
&lt;BR /&gt; disconnected 
&lt;BR /&gt;Job Proof2 ended at 16:40 20/08/2013.</description>
      <pubDate>Tue, 20 Aug 2013 16:55:25 GMT</pubDate>
      <guid>https://community.qlik.com/t5/Talend-Studio/Using-tContextLoad-and-tFixedFlowInput-for-Input-Parameters-to/m-p/2373067#M135831</guid>
      <dc:creator>_AnonymousUser</dc:creator>
      <dc:date>2013-08-20T16:55:25Z</dc:date>
    </item>
    <item>
      <title>Re: Using tContextLoad and tFixedFlowInput for Input Parameters to MSSqlSP</title>
      <link>https://community.qlik.com/t5/Talend-Studio/Using-tContextLoad-and-tFixedFlowInput-for-Input-Parameters-to/m-p/2373068#M135832</link>
      <description>I would say that you've either defined your context parameter as a string rather than a number, of you've double-quoted it when referring to it.</description>
      <pubDate>Tue, 20 Aug 2013 17:03:26 GMT</pubDate>
      <guid>https://community.qlik.com/t5/Talend-Studio/Using-tContextLoad-and-tFixedFlowInput-for-Input-Parameters-to/m-p/2373068#M135832</guid>
      <dc:creator>Anonymous</dc:creator>
      <dc:date>2013-08-20T17:03:26Z</dc:date>
    </item>
    <item>
      <title>Re: Using tContextLoad and tFixedFlowInput for Input Parameters to MSSqlSP</title>
      <link>https://community.qlik.com/t5/Talend-Studio/Using-tContextLoad-and-tFixedFlowInput-for-Input-Parameters-to/m-p/2373069#M135833</link>
      <description>You can't use context variables in the Inline Content(delimited file) option as the contents of that box are treated as if they were being read from a delimited file (funnily enough) i.e. it's trying to put the words "context.intLogTypeId" into the first column of your schema.  Use the Single Table option instead.</description>
      <pubDate>Wed, 21 Aug 2013 15:11:18 GMT</pubDate>
      <guid>https://community.qlik.com/t5/Talend-Studio/Using-tContextLoad-and-tFixedFlowInput-for-Input-Parameters-to/m-p/2373069#M135833</guid>
      <dc:creator>alevy</dc:creator>
      <dc:date>2013-08-21T15:11:18Z</dc:date>
    </item>
    <item>
      <title>Re: Using tContextLoad and tFixedFlowInput for Input Parameters to MSSqlSP</title>
      <link>https://community.qlik.com/t5/Talend-Studio/Using-tContextLoad-and-tFixedFlowInput-for-Input-Parameters-to/m-p/2373070#M135834</link>
      <description>Thank you, finally managed to get this working using 'Single Table' as suggested &lt;span class="lia-unicode-emoji" title=":slightly_smiling_face:"&gt;🙂&lt;/span&gt;</description>
      <pubDate>Wed, 28 Aug 2013 15:01:55 GMT</pubDate>
      <guid>https://community.qlik.com/t5/Talend-Studio/Using-tContextLoad-and-tFixedFlowInput-for-Input-Parameters-to/m-p/2373070#M135834</guid>
      <dc:creator>_AnonymousUser</dc:creator>
      <dc:date>2013-08-28T15:01:55Z</dc:date>
    </item>
  </channel>
</rss>

