EXCEL file reading from C# code

There is require installing of DocumentFormat.OpenXml from nuget in visual studio or download DocumentFormat.OpenXml.dll and use in the project. Below is the code for reading Excel file and stored data in dataset. Namespaces: using DocumentFormat.OpenXml;using DocumentFormat.OpenXml.Packaging;using DocumentFormat.OpenXml.Spreadsheet;using System;using System.IO;using System.Collections.Generic;using System.Data;using System.Linq;using System.Text;using System.Threading.Tasks;using System.Configuration;using System.Text.RegularExpressions; Method for Reading EXCEL […]

Mapping with Envelop schema error

Error details: The Messaging Engine failed while executing the outbound map for the message going to the destination URL <URL> with the Message Type <Message Type>. Document type <Document Type Name> does not match any of the given schemas. Reason:  This is happening when there is used Envelop schema as […]

Tracking Messages in BizTalk

Microsoft BizTalk server provides a great feature of message tracking. We can track each message processed in BizTalk either success or failure. For failure message we always check in suspended instance in BizTalk Admin console group hub. Or provide some exception management e.g. ESB management console to handle fault message […]

Implement XSLT in BizTalk mapping

There are two ways to implement custom xslt in BizTalk mapping. Implement xslt for full mapping partially implement xslt by using Script functoid Implement xslt for full mapping: Microsoft provides very rich features for mapping. still if there is require for custom xslt then also its make easy to create […]