title: Conditional Split in SSIS based on the number of times a character appears in a string
body: <p>I would like to split the flow of data based on the number of times a particular character appears in a string.</p>
  
  <pre><code>Source Data:  
  R1 - 123@abc.com  
  R2 - 567@stu.com  
  R3 - 234@fgh.com,456@xyz.com  
  R4 - 567@wxy.com,789@pqr.com  
  R5 - 678@def.com  
  </code></pre>
  
  <p>As seen above, 2 of the four records contain the "@" symbol twice. I want to split data based on the number of times this character appears in a line</p>
  
  <pre><code>Expected result  
  Flat_File_Once (3 rows)  
  R1 - 123@abc.com  
  R2 - 567@stu.com  
  R3 - 678@def.com  
  
  Flat_File_Twice (2 rows)  
  R1 - 234@fgh.com,456@xyz.com  
  R2 - 567@wxy.com,789@pqr.com
  </code></pre>
  
  <p>This works in SQL, not sure how to do it in SSIS</p>
  
  <pre><code> len(email) - len(replace(email, '@', '')) &gt; 1
  </code></pre>