title: How do I capture the single row value from Execute SQL Task that uses an expression?
body: <p>I have an Execute SQL Task using this expression:</p>
  
  <pre><code>@[User::SQLExportError] + (DT_WSTR,30)@[User::Id]
  </code></pre>
  
  <p>The expression evaluates correctly to:</p>
  
  <pre><code>  select count(*) as ErrorTableCount from [myschema].Error 
      where SPName in ('export/INSERT','export/DELETE') and Id = 1000
  </code></pre>
  
  <p>In this same sql task I want to capture the <strong><code>as ErrorTableCount</code></strong> into a single row result set with the ResultName called: <em>ErrorTableCount</em> Variable Name called: <code>User::ErrorTableCount</code></p>
  
  <p>I am getting the red circle/x cross telling me: </p>
  
  <pre><code>There were errors during task validation.
  </code></pre>
  
  <p>There seems to be some conflict between using an expression for the sql source and within that expression containing the the dubbed count name defined under the result set. Any advice/ideas?</p>