How to put password in BizTalk WCF-SQL Binding (Error: Value cannot be null)

Error When you try to manually set the SQL password on a WCF SQL port in a binding file, you might get tthis error: Error Description: System.ArgumentNulLException: Value cannot be null. Parameter Name: Password Solution The scenario is typically that you export a binding file from BizTalk. The exported file will never contain the actual […]

BizTalk – Send Dynamic File from Orchestration

Suppose you have StartMsg and you want to send it to a dynamic disk path. I would build another new message called StartMsgDyn. If you want to use a GUID to make the file unique, as I do in my example code below, then create an orchestration variable called “GuidVar” of type of .NET Class […]

Quick Summary XREF to All My BizTalk SQL Commands

Over time, I have found or developed several T-SQL (Transact-SQL) commands that you can run to help cross reference (XREF) various BizTalk entities. Most of these run against the BizTalkMgtmDB database. Here is a list of them, so they are easy to find: BizTalk SQL Queries 1. Simple list of Receive Ports and Receive Locations […]