<?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: IN and OUT parameters in tJDBCSP connecting to MS SQL Server in Talend Studio</title>
    <link>https://community.qlik.com/t5/Talend-Studio/IN-and-OUT-parameters-in-tJDBCSP-connecting-to-MS-SQL-Server/m-p/2217703#M13184</link>
    <description>The record set schema must fit to the fields (by name!) which your query or procedure provides as output. It sound like you are trying to read a date from a none date column - typically an problem in addressing the correct field.</description>
    <pubDate>Thu, 15 Nov 2012 21:26:01 GMT</pubDate>
    <dc:creator>Anonymous</dc:creator>
    <dc:date>2012-11-15T21:26:01Z</dc:date>
    <item>
      <title>IN and OUT parameters in tJDBCSP connecting to MS SQL Server</title>
      <link>https://community.qlik.com/t5/Talend-Studio/IN-and-OUT-parameters-in-tJDBCSP-connecting-to-MS-SQL-Server/m-p/2217702#M13183</link>
      <description>I need to invoke a MS SQL Server SP that runs in the SQL Server Studio like so:
&lt;BR /&gt;EXEC . @startDate = N'11/08/2012'
&lt;BR /&gt;Am able to see results when I run the SP in MS SQL Server Studio 2008.
&lt;BR /&gt;I followed the steps shown in this post 
&lt;BR /&gt;
&lt;A href="http://www.talendforge.org/forum/viewtopic.php?pid=30420#p30420" target="_blank" rel="nofollow noopener noreferrer"&gt;http://www.talendforge.org/forum/viewtopic.php?pid=30420#p30420&lt;/A&gt;
&lt;BR /&gt;but am getting a null pointer on the result set.
&lt;BR /&gt;UPDATE: I changed the SP component to tMSSqlSP and now am able to see a result set, but now I am getting a date parse error in tParseRecordSet_1.</description>
      <pubDate>Wed, 14 Nov 2012 05:37:20 GMT</pubDate>
      <guid>https://community.qlik.com/t5/Talend-Studio/IN-and-OUT-parameters-in-tJDBCSP-connecting-to-MS-SQL-Server/m-p/2217702#M13183</guid>
      <dc:creator>jtalend</dc:creator>
      <dc:date>2012-11-14T05:37:20Z</dc:date>
    </item>
    <item>
      <title>Re: IN and OUT parameters in tJDBCSP connecting to MS SQL Server</title>
      <link>https://community.qlik.com/t5/Talend-Studio/IN-and-OUT-parameters-in-tJDBCSP-connecting-to-MS-SQL-Server/m-p/2217703#M13184</link>
      <description>The record set schema must fit to the fields (by name!) which your query or procedure provides as output. It sound like you are trying to read a date from a none date column - typically an problem in addressing the correct field.</description>
      <pubDate>Thu, 15 Nov 2012 21:26:01 GMT</pubDate>
      <guid>https://community.qlik.com/t5/Talend-Studio/IN-and-OUT-parameters-in-tJDBCSP-connecting-to-MS-SQL-Server/m-p/2217703#M13184</guid>
      <dc:creator>Anonymous</dc:creator>
      <dc:date>2012-11-15T21:26:01Z</dc:date>
    </item>
  </channel>
</rss>

