Site Archives Biztalk Tutorial
Updategram with multiple tables with foreign keys
Updategram Overview
Since SQL Server 2000, updategrams along with OPENXML have been available to insert, update, or delete data using XML documents. An updategram works against the XML views that are provided by the annotated XSD schema that contains the information required to map to the tables and columns to be modified. Using an [...]
Setting up an HL7 Solution
Setting up an HL7 Solution
HL7 Accelerator Overview
As you might know, the BizTalk Accelerator for HL7 offers a great deal of enhanced messaging capabilities for the healthcare industry. Although it is offered as a separate download, it comes with the license of BizTalk. The nice part about it is that it offers all of [...]
Import flat file using BizTalk server
Recently I worked with a client to implement a solution to import data from an Excel file to SQL Server database. In order to provide a seamless user experience, we created a web page to allow user to upload file to server, then use BizTalk server to convert Excel file to XML file and call [...]
Find It Quickly
Find what you're looking for quickly by using our keyword search. Can't find it? Try our links below.