How to read text file block by block based on header code in SSIS

• squvi.87

  Default port

  Points: 1450

  More actions

  September 20, 2017 at 1:15 am

  #340169

  1. I have table which consist of several header code (it always starts with HDR)
  2. Every header will have its own BHD(start) and BTR(end) tags

  I Need to add corresponding header value to each block as a new column.
   

• Eirikur Eiriksson

  SSC Guru

  Points: 182912

  More actions

  September 20, 2017 at 5:01 am

  #1960122

  The simplest way is to import the file line by line into a table and then parse it, the parsing can easily be done in a view.
  😎