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 file public static DataSet ReadExcelFile(string … Continue reading EXCEL file reading from C# code

JSON Error: Input string was not in a correct format

Error Details: There was a failure executing the send pipeline <Pipeline Name> Source: "JSON encoder" Send Port: <Send Port Name> URI: <URI> Reason: Input string was not in a correct format. Reason: Most of the time when we generate schemas with XML or JSON or csv files with specified wizard (JSON Schema wizard, Flat File … Continue reading JSON Error: Input string was not in a correct format

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 destination schema in mapping. And … Continue reading Mapping with Envelop schema error

BizTalk with Rest Service Form-Data

when there is requirement to consume REST web service in Form-Data. BizTalk need to send request to REST Service in Form-Data format. And BizTalk always send data in JSON raw format by default. If we change the content type on send port still doesn’t work. So before sending file to REST Service, we need to … Continue reading BizTalk with Rest Service Form-Data

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 and stored the message. For … Continue reading Tracking Messages in BizTalk

Implement XSLT in BizTalk mapping

There are two ways to implement custom xslt in BizTalk mapping. Implement xslt for full mappingpartially 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 xslt by BizTalk mapping. just right … Continue reading Implement XSLT in BizTalk mapping