For example, to put a pound (or hash) sign # in an XML file, you can use either of the following: ASCII decimal and Hex values in XML <pre> # or # </pre> 23 in hex = 2×16+3 = 35 in decimal So the syntax is the ampersand and the hash tag followed by the […]
Query.exe is the implementation of the Saxon XQuery command/engine. It’s a command line program that I’m running from the Windows command prompt. Issue <pre> C:\XMLClass\XQuery>c:\Saxonica\bin\Query.exe -q:Flight3_Xquery.txt -o:flight3_xquery_out.xml Error on line 2 column 20 of Flight3_Xquery.txt: XPDY0002: The context item for axis step root/descendant::FlightLeg is absent Query failed with dynamic error: The context item for axis […]
While BizTalk includes an XML to XSD schema utility, we can do the same thing in C# or PowerShell (version 5.1 used in this example, but most of the work is done by .Net classes). The .NET System.Xml libraries include something interesting called the XmlSchemaInference object. It can basically look at the XML data file, […]
Today, I was driven crazy by the Pipeline Editor in Visual Studio. I dropped two different pipeline components in it, then when I closed and re-opened it they would show the same name. When I opened the .btp file in a text editor it looked okay. So it was apparently a problem displaying the user […]
The .NET System.Message class allow for isHTMLBody to be true or false. Setting to true allows you to use HTML to make fields bolds, to use headers, to change colors, fonts, etc… But sometimes you prefer just a text email. In an HTML email, you cna use (break HTML) to create new lines. In a […]
NOTE: I highly recommend that you create a folder in Task Scheduler for your company name. Do not mix your scheduled tasks with those that are there under various Windows features. Open Windows “Task Scheduler”, and create a task. Give it a name and a schedule. The part most people have questions about is the […]
Frequently, we get monitor alerts that the disk is under 20% full. The question is usually what files are large that can be deleted. I often use the fantastic utility WinDirStat. And there are PowerShell commands to show you the top files on the disk. But typically, some of the largest files are the paging […]
How do you create an identical copy of a BizTalk ReceiveLocation within a Receive Port? Well, it cannot be 100% identical. The name will of course have to change, the URI will have to be unique as well. I recently had a case where we wanted the same orchestration to run on two different databases […]
How do you create an identical copy of a BizTalk SendPort except for the name? It’s not uncommon for me to want create a duplicate of a SendPort, especially if it’s a more complicated SendPort like WCF or SQL with lots of parameters. I finally wrote a PowerShell to do this. Maybe later, I’ll do […]
In BizTalk, you can export and import and export bindings to/from the BizTalk Database using the BizTalk Administration Console and/or BTSTask.exe (command line utility). The binding file has five major sections: 1) ModuleRefCollection (Orchestrations a.k.a. “Services” and Orchestration bindings) 2) SendPortCollection (Send Ports) 3) DistributionListCollection (Send Port Groups) 4) ReceivePortCollection (Receive Port and their related […]