title: Return Integer value from SSIS execute SQL Task
body: <p>I am using SQL Server 2005 Business Intelligence Studio and struggling with returning an integer value from a very simple execute SQL Task. 
  For a very simple test, I wrote the SQL Statement as:
      <pre><code>Select 35 As 'TotalRecords'</code></pre></p>
  
  <p>Then, I specified ResultSet as</p>
  
  <pre><code>ResultName = TotalRecords and
  VariableName = User::TotalRecords
  </code></pre>
  
  <p>When I execute this, the statement is executed but the variable doesn't have the updated value. However, it has the default value that I specified while variable definition.</p>
  
  <p>The return of a date variable works, but integer variable isn't working. The type of <code>User::TotalRecords</code> specified is Int32 in a package scope.</p>
  
  <p>Thanks for any hints</p>