title: How to use Count function in Conditional Split Transformation in SSIS
body: <p>Can someone help me here with the SSIS Conditional Split Transformation. I want to do a <code>Count(Column)</code>. The requirement is ;</p>
  
  <blockquote>
    <p>"If the record count exceed 100 records, then move to one output, else move to another output".</p>
  </blockquote>
  
  <p>I am trying to use this, but not able to get it done.</p>
  
  <pre><code>COUNT(FirstName1) &gt; = 100
  </code></pre>
  
  <p>Appreciate your help on this.</p>