In Microsoft SQL, how can we group by a date, when the column we want to group by is a date time? For example, you want the number of rows created for each date, and you have a column in the database called Date_Added (or in my example below, TrcDateTime). Code Sample 1: <pre> select […]
It’s long been said that a picture is worth a thousand words. I think it’s necessary to have a few diagrams to show the BizTalk flow of any application. I’m not happy with UML, because they don’t show the many aspects of BizTalk. I’ve walked into companies before that had no diagram, and the first […]
One way to check for missing data is to do an xpath count. The two-step approach (put the xpath in a variable first). Some might find this code cleaner, but you use a variable. Note that you have to use the conversion statement to convert the string result of the xpath to a number, if […]
If you get the error “An xpath expression must be of the form …” (in an expression shape of a BizTalk orchestration), here’s one possible solution. I was using a multi-part message, so instead of msgCreateSPServiceOrderAckResp, I had had to specify msgCreateSPServiceOrderAckResp.parameters. The compiler just shows the error “The expression that you have entered is […]
In a previous article, we discussed how to use a Powershell job to delete files over a certain age. But what if if you want to do it using straight “pure” DOS .bat or .cmd file? The following shows you how it’s done: REM Cleanup all files more than 7 days old e: cd E:\BizTalk\App\Backup […]
This video gives an idea of some of the projects a BizTalk Architect are involved with. Neal Walters has worked in a number of industries, including: Oil and Gas, Mortgage, Banking, Manufacturing and Reverse Logistics, Government, Healthcare, Insurance, Aviation/Airline Fueling, Student Loans and Non-Profits. Neal started with mainframes back in 1981 with Amerada Hess Corporation […]
I have a C# trace routine, that writes data to a SQL Trace table. It’s kind of like my own Log4Net, and allows a unified trace between BizTalk, WebServices, and other types of progams. I had the interesting task the last month of writing a WCF Custom Behavior to make JSON work in BizTalk 2010. […]
I have a “Website” in IIS. It had a virtual directory with SSL working. I added a second virtual directory for another external client. I’m using SOAP-UI to test. It works fine with normal http, but gives an http status of 404 when I use https. Example URL: https://wstest.mydomain.com/App1/myService.svc https://wstest.mydomain.com/App2/myNewService.svc I’ve looked at the IIS […]
Issue/Scenario: I have a new application that I’m building. I have for example three projects, App.Common, App.In, and App.Out. We have a somewhat debatable policy of keeping one app separate from the others and almost no application cross-references (still on BizTalk 2010 – but in 2013 this is supposed alleviated, partially or in whole). I […]
First download the C+ distributable from Microsoft: Download 64 Download the CURL MSI from here: Download CURL MSI Install will default to this directory, and here is the curl.exe: “c:\Program Files\cURL\bin\curl.exe”. You need to find the MSI. Many downloads of CURL will include the source code and it requires you to build it with C++ […]