<div>
<div class="content wysiwyg-content">
Environment: C#.Net, Sql Server 2000<br />
<br />
I am going to receive a HL7 based txt file that contains record information.<br />
Historically, we have always received a normal string length delimited txt file but I am informed going forward its going to be HL7 based.<br />
<br />
From what I understand its a standard or format that everybody is supposed to adhere to.<br />
<br />
My question is what would I have to change in our .Net application and the SQL server database schema to process this HL7 txt file?<br />
<br />
I read somewhere about Iguana but am not sure how it fits in all this?<br />
<br />
Thanks!
</div>
</div>


Environment: C#.Net, Sql Server 2000

I am going to receive a HL7 based txt file that contains record information.
Historically, we have always received a normal string length delimited txt file but I am informed going forward its going to be HL7 based.

From what I understand its a standard or format that everybody is supposed to adhere to.

My question is what would I have to change in our .Net application and the SQL server database schema to process this HL7 txt file?

I read somewhere about Iguana but am not sure how it fits in all this?

Thanks!

HL7 software and hardware requirements

Extensible Markup Language (XML) refers to the encoding of documents such that they can be read by both machines and humans. XML documents use tags to show the beginning and end of a set of data. XML is used extensively on websites to show volumes of data, and is the default for a number of office productivity suites. This topic includes discussions of XML-related technologies, such as XQuery (the XML Query language), XPath (the XML Path language), XSLT (eXtensible Stylesheet Language Transformations), XLink (the XML Linking language) and XPointer (the XML Pointer language).

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.

Microsoft SQL Server

C# is an object-oriented programming language created in conjunction with Microsoft’s .NET framework. Compilation is usually done into the Microsoft Intermediate Language (MSIL), which is then JIT-compiled to native code (and cached) during execution in the Common Language Runtime (CLR).