title: how many result test we can give a for execute sql task
body: <p>I have an <code>ssis package</code> which have a <code>exectue sql</code> task it. I tried to modify the task by adding a <code>stored procedure</code> as sql statement. The <code>stored procedure</code> returns two result sets. </p>
  
  <p>stored procedure:</p>
  
  <pre><code>create proc test
  as
  begin
  
  select EmpID from Employee
  
  select PersonID from person
  end
  </code></pre>
  
  <p>I mapped the <code>result sets</code> to <code>result</code> set tab in the task with <code>parmeter name 0</code> <code>&amp; 1</code> and assigned them to two <code>variables</code>.</p>
  
  <p><a href="https://i.stack.imgur.com/li1sO.png" rel="nofollow"><img src="https://i.stack.imgur.com/li1sO.png" alt="enter image description here"></a></p>
  
  <p>When I run the package I got below error</p>
  
  <blockquote>
    <p>[Execute SQL Task] Error: There is an invalid number of result
    bindings returned for the ResultSetType: "ResultSetType_Rowset".</p>
  </blockquote>
  
  <p>However if i delete one <code>result set</code>  and execute <code>package</code> , it runs successfully. Is it possible to add more than one result set to execute sql task?  What I am missing here? </p>
  
  <p>Thank you</p>