title: SSIS Execute SQL Task Stored Procedure returning empty result sets
body: <p>I have a simple stored procedure that returns 1 row with 3 columns. I am trying to create an SSIS package that reuses the values in these columns later. If I run a simple select query everything is happy but when I run the stored procedure I get the following error: </p>
  
  <blockquote>
    <p>[Execute SQL Task] Error: Executing the query "rs_UpdateMemberExtract"
    failed with the following error: "Unable to populate result columns
    for single row result type. The query returned an empty result set.".
    Possible failure reasons: Problems with the query, "ResultSet"
    property not set correctly, parameters not set correctly, or
    connection not established correctly.</p>
  </blockquote>
  
  <p>I've set up an ado.net connection and the proc runs correctly in SSMS, I have the task set up like follows:</p>
  
  <pre><code>ConnectionType: ADO.NET
  Connection: ServerName.connectionName
  SQLSourceType: Direct Input
  SQLstatment: Name of Proc (rs_UpdateMemberExtract)
  IsQueryStoredProcedure: True
  </code></pre>
  
  <p>I have each parameter mapped to a variable and the direction set to Output</p>
  
  <p>I have the name of each column that should be returned in the result set and mapped to the associated variable.</p>
  
  <p>The task works if I set the ResultSet to 'None',  </p>
  
  <p>Any ideas What I've missed?</p>
  
  <p>Thanks</p>