title: SSIS parsing of an irregular flat file?
body: <p>I'm pretty familiar with SSIS parsing of regular delimited text data files, however, I'm looking for some advice on an approach to tackle a file that looks like this test file:</p>
  
  <pre><code>ISA*00* *00* *01*220220220 *ZZ*RL CODE 01*060327*1212*U*00300*000008859*0*P*:~
  GS*RA*CPA-BPT*LOCALUTILITY*060319*1212*970819003*X*003030~
  ST*820*000000001~
  BPR*C*321.91*C*X12*CBC*04*000300488**9918939***04*000300002**1598564*070319~
  TRN*1*00075319970819105029~
  REF*RR*0003199708190000174858~
  DTM*097*070318~
  DTM*107*070318~
  N1*PR*DIRECT PAYMENT~
  N1*PE*ABC CORPORATE BILLER*ZZ*90005836~
  ENT*1~
  N1*PR*BILLING - TEST - NATTRASS~
  RMR*CR*0009381082105011**142.15~
  REF*TN*000303965~
  DTM*109*070316~
  ENT*2~
  N1*PR*BILL FREID TEST~
  RMR*CR*0011010451800011**179.76~
  REF*TN*000304189~
  </code></pre>
  
  <p>The 321.91 is the total of the transaction.  </p>
  
  <p>I would prefer to do this with SSIS, but could also do create a C# parser.</p>
  
  <p>Suggestions would be appreciated.</p>
  
  <p>Thank you.</p>