title: Stored data set from stored procedure - Execute SQL Task
body: <p>I have this stored procedure:</p>
  
  <pre><code>Dbo.SprocName (@Id UNIQUEIDENTIFIER, 
                 @ResponseCode INT OUTPUT,
                 @ResponseDescription VARCHAR(500) OUTPUT)
  </code></pre>
  
  <p>And it returns a dataset called say <code>Result</code> as a <code>nvarchar(MAX)</code> (always a single row).</p>
  
  <p>I've tried OLE and ADO connections and as well as result sets. I've tried creating a table variable and storing the value there.</p>
  
  <p>Nothing works.</p>
  
  <p>I can see in the database that it's running successfully then it fails when returning the result data set. </p>
  
  <p>I’ve done some debugging and I can assure the result string is returned as should be. The problem is that I don’t know how to handle this on SSIS.</p>
  
  <p>The error that I get is: </p>
  
  <blockquote>
    <p>Input string was not in a correct format</p>
  </blockquote>
  
  <p>I appreciate any ideas.</p>
  
  <p>Thanks.</p>
  
  <p><strong>EDIT</strong>: I have tried using a table variable again and it works. I guess I didn't do it well first time. sorry about that. Thanks!</p>