title: How to proceed to the next task only if no records exist for a given query?
body: <p>I have the following piece of SQL that will check if any duplicate records exist. How can I check to see if no records are returned? I'm using this in an SSIS package. I only want it to proceed to the next step if no records exist, otherwise error.</p>
  
  <pre><code>SELECT      Number
          ,   COUNT(Number) AS DuplicateCheckresult
  FROM        [TelephoneNumberManagement].[dbo].[Number]
  GROUP BY    Number
  HAVING      COUNT(Number) &gt; 1
  </code></pre>