Hi,

I have to create a parser that can parse a HL7 Message and load the data result into aSQL Server.

Does any one have any idea about this ?



Thanks
Sudheer

for HL7 Google gives us "http://www.interfaceware.com/manual/hl7.html" among others.

for the SQL interface try System.Data.SQL namespace.

write back when you've studied those a little...

What you don't know can hurt you!

Why don't you try Pervasive Software? they can help you with custom codes and finding the right connector to help you with HL7 translation.

For the MS SQL Database look at the UltraPort MS SQL Schema Engine for HL7. It does exactly what you need, it's easy to set up, has a free trial and good support. http://www.hermetechnz.com/EasyHL7/Prod_SQL.asp

That SQL product can actually give you an entire platform to work from which means that you don't "need" any special toolkit. But, if you do want to work with the Raw HL7 in Visual Studio .Net look at this .Net Class Library http://www.hermetechnz.com/EasyHL7/Prod_ManagedCode.asp

Hope this helps.