Parsing EDI 837 file in SQL data tables or in XML

See more:

C#

SQL

server

EDI

Hi,

I am working with EDI 837 files. I need to parse them to insert into a single SQL table. After I will process 977, 237 and prepare 835 with my system data.

Is there any way to parse and insert the data into a single claim file.

Anyone can recommend any tool which can be used for this process.

My organization can buy the licence also. Please give me detail about the tools which deals automatic process of these files.

Thanks & Reagrds
Supratik De

What I have tried:

I tried to parse the data and insert via an open source to create database and split the entire data into tables with all the keywords - IKA, BHT, ST etc. Now I want to make a single table whose single row will define a single claim. I am not getting the proper mapping relation among the tables for the joining keys - TransactionsetId, InterchangeId. I assume the ParentLoodId and LoopId means in the hierarchy the child's parent loop id will be parent's loop id. Is it correct. How the hierarchy has been defined.