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

    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.
     

  • 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.
    😎

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply