title: Delete rows from CSV
body: <p>I need to remove rows from CSV file using C# in SSIS </p>
  
  <p>Here is my file </p>
  
  <pre><code>XXXX,,,,,,,
  XXXX111,,,,,,,
  XXXX222,,,,,,,
  A,b,c,d,e,f
  g,h,i,j,k,l
  1,2,3,4,5,6
  ,,,,,,,,,,,
  ,,,,,,,,,,,
  ,,,,,,,,,,,
  </code></pre>
  
  <p>Here is how my output should look like </p>
  
  <pre><code>A,b,c,d,e,f
  g,h,i,j,k,l
  1,2,3,4,5,6
  </code></pre>
  
  <p>Basically i need to remove </p>
  
  <pre><code>XXXX,,,,,,,
  XXXX111,,,,,,,
  XXXX222,,,,,,, 
  ,,,,,,,,,,,
  ,,,,,,,,,,,
  ,,,,,,,,,,,
  </code></pre>
  
  <p>Thanks in advance </p>