Powershell to Rename Visual Studio Solution

Have you ever wanted to make a new Visual Studio solution (even a BizTalk one) as a copy of another, except just change the program names? And it would automatically rename everything, including the solutions, project files, assembly files and so on? I’ve needed this program for years, and finally wrote it! Remember that the […]

BTDF Domain accounts must include the domain name. Local accounts must not include a domain or computer name.

BTDF (BizTalk Deployment Facility) gave this error during a deploy in Visual Studio to the local machine: Error: Domain accounts must include the domain name. Local accounts must not include a domain or computer name. Other people mention that you are using computer or domain account when the other is needed. In my case, my […]

BizTalk Sql Query to Lookup Party/Profile based on an identifier

You might open a file like this: ISA*00*          *00*          *ZZ*123000013      *ZZ*ABC3001        *160719*1600*U*00401*201160030*0*P*;~ and then want to know what is company with ID=123000013? I don’t know of any any way in the BizTalk Admin console to do a reverse lookup like this. <pre> select        P.PartnerId as 'ParterID',        P.Name as 'PartyName',        BP.Name as 'ProfileName',      BP.ProfileID,      BI.Qualifier, […]

Batch file script to download (clone) a specific branch from Git

We are using GitLab, an open source way to store source code on your own servers. I wanted to get all my branches into a clean directory, then recompile them to make sure everything had been checked-in properly. THe first step is to download all the branches into a directory. NOTE: Apparently the –single-branch option […]

Updated InsertGenerator to Handle Schema name when generating SQL insert statements

This is an updated version of “InsertGenerator” from CodePlex. This tools works great when you want to create a few insert statements from a table, and save them in a file; or to transfer a few rows from one system to another. It’s great for lookup/code tables I referred to this “how to build sql […]

Misleading BizTalk Error: Loading property information list by namespace failed or property not found in the list. Verify that the schema is deployed properly.

Error that I had to solve today <pre> The Messaging Engine failed while executing the inbound map for the message coming from source URL:"\\EDI1-FTP\Integrations\EDI1\ABCD\inbound\990\*.*" with the Message Type "http://MyComapny.Schemas.EDI.X12_00401.EDI990/v1.0#X12_00401_990". Details:"Loading property information list by namespace failed or property not found in the list. Verify that the schema is deployed properly. " </pre> My Solution I […]

Failure executing the receive pipeline: Reason: Finding the document specification by message type

Error Got the following error when posting to a BizTalk receive location from SOAP-UI, but could have happened with any type of receive location: <pre> HTTP/1.1 500 Internal Server Error Content-Type: application/xml; charset=utf-8 Server: Microsoft-IIS/8.5 X-Powered-By: ASP.NET Date: Thu, 05 Jul 2018 14:07:37 GMT Content-Length: 2384 <Fault xmlns="http://schemas.microsoft.com/ws/2005/05/envelope/none"><Code><Value>Receiver</Value><Subcode> <Value xmlns:a="http://schemas.microsoft.com/net/2005/12/windowscommunicationfoundation/dispatcher"> a:InternalServiceFault</Value></Subcode></Code><Reason><Text xml:lang="en-US"> There was a […]

Powershell – Find Most Recent 12 Files from Folder Pattern

My disk folder structure is like this: D:\Application\DEV D:\Application\DEV\Cust1 D:\Application\DEV\Cust1\Archive D:\Application\DEV\Cust1\Archive\210 D:\Application\DEV\Cust1\Archive\204 D:\Application\DEV\Cust1\Inbound D:\Application\DEV\Cust1\Inbound\204 D:\Application\DEV\Cust1\Inbound\210 D:\Application\DEV\Cust1\Outbound D:\Application\DEV\Cust1\Outbound\204 D:\Application\DEV\Cust1\Outbound\210 Similar for \Cust2 Similar for \Cust3 etc I was looking for a sample 210 EDI Invoice to use in testing; and I wanted the most recent ones. It turns out you can put a wildcard in the […]

What is the \App_Data\Temp\WcfServiceDescription.xml and how can it be used?

Any time you use the BizTalk WCF Service Publishing Wizard, it creates an IIS website with various content, including a “Temp” directory. The Temp directory has two entries: 1) BindingInfo.xml – can be used to create a Receive Port and Receive Location tied to your published web service 2) WcfServiceDescription.xml – this is the one […]

How to Create a Request-Only (No Response) WCF Service

To create a request-only (or one-way) webservice in BizTalk using the WCF-Service-Publishing-Wizard can be a little confusing at first. After the first couple of screens, the wizard shows the screen below You cannot delete the Response message. What you have to do is delete Operation1, then right click on the Service, select “Add Web method.”, […]