title: How to return a failure if a table is empty
body: <p>Using SQL Server 2005, but still using DTS.  I need to add a step to check if a table is empty, and somehow fail the step if it is.  It's easy checking if the table is empty:</p>
  
  <pre><code>Select count(*) from source_table
  </code></pre>
  
  <p>But returning 0 is a success, too.  If it is 0, I want a failure (so that I can fork to a different option, email us, skip some steps).</p>