title: "[Amazon][ODBC] (11310) SQL C type not supported." Error while using "Execute SQL Task" with Single Row ResultSet through Redshift
body: <p>I have created a <code>Execute SQL Task</code> to query <code>Redshift</code> and save the <code>Single Row resultset</code> to a variable using <code>SSIS</code>. I am using <code>ODBC</code> connection and query is as simple as: </p>
  
  <pre><code>select 1 as id
  </code></pre>
  
  <p>I have set the <code>ResultSet</code> properties to <code>Single row</code> and assigned the <code>Result Name=1</code> to a variable. </p>
  
  <p>When I execute the task with setting the <code>Resultset=None</code> it works with no error but when I execute it with <code>Resultset=Single row</code> I see this error:</p>
  
  <blockquote>
    <p>[Execute SQL Task] Error: An error occurred while assigning a value to variable "variable_name": "[Amazon][ODBC] (11310) SQL C type not supported.".</p>
  </blockquote>