Modify the .txt Source file which has header size 702 bytes and data row size 570 bytes.

• ranjith_punneli

  Newbie

  Points: 7

  More actions

  September 8, 2008 at 5:12 am

  #125373

  Hi all,

  I am new to the SSIS package and I need help from u guys....

  Requirement:

  Need to import a .txt Source file to a Database table.

  The format for the .txt file is:

  Contains Headers which is starting with one and of total row size 702 bytes.Contains Data Rows which is starting with 2 and of total size 570 bytes.When we are importing the data rows we need to map the header data to some fields in the table till we find a record which is starting with 8.If we find a record which is starting with 8, then the next row will be again a header starting with one and all the records under that will be data rows which has to be imported to the database table with new header values.The process goes on lek this.

  How to achieve this??

  Regards,

  Ranjith

• Mukti

  SSCrazy

  Points: 2826

  More actions

  September 9, 2008 at 2:27 pm

  #869301

  I assume the header info is same for all. If thats the case then you can use conditional split to split the header rows from data rows.

  HTH

  ~Mukti