title: SSIS skip bad row
body: <p>I have a file expecting 8 chars per line that I want to load to a table in SQL Server</p>
  
  <pre><code>ABCD1234
  ABCD5678
  !
  DCBA4321
  DCBA9876
  &gt;
  ABCDEFGH
  </code></pre>
  
  <p>However I may get bad rows. With SSIS I tried all the 3 methods:
  Determined with {CL}{RF}, fixed width and finally Ragged Right.
  In all cases parsing fails and is redirected to the error table. When I remove the bad lines, everything is fine. </p>
  
  <p>What is strange is that with a small sample like this it still works and is inserted to the expected table.
  When file is big, parsing may fail not at the first bad row but second or third and insert all the rest in the ERROR Table.</p>
  
  <p>Isn't it supposed to skip the bad row and insert the good ones in the expected table even when they come after?
  Or is there another solution?</p>