Author: Admin

I was at a new client, trying to run a Powershell to help build my BizTalk binding files for the BizTalk Deployment Framework, and I got this error: PS C:developmentAllProjects.Deployment> .GenerateMasterBindingsFromLocal.ps1 File C:developmentAllProjects.DeploymentGenerateMasterBindingsFromLocal.ps1 cannot be loaded because the execution o f scripts is disabled on this system. Please see "get-help about_signing" for more details. At […]

Got this error when importing a series of 5 SendPorts into a newly created BizTalk application: Failed to update binding information. (mscorlib). Additional Information: Object reference not set to an instance of an object. (Microsoft.BizTalk.ExplorerOM). My solution was that I needed to make a reference from the new application, to an existing application, which contained […]

The first issue is that you typically need secure SFTP. Biztalk 2010 finally comes with a secure FTP, but it’s FTPS (FTP over SSL) instead of SFTP (MSDN Community Link). There is an open-source adapter available here: http://sftpadapter.codeplex.com. On the other hand, you can use normal FTP, but use some type of encryption that can […]

Methods to Learn BizTalk There are three ways to learn BizTalk. Buy a book, read it. This is a great way to learn BizTalk if you are on a bus, plane or train. Pay about $2500 to attend a class, plus up to an additional $2500 for travel expenses if the class is not in […]

Back in 2009, I did a short BizTalk project that used Host Initiated Processing (aka “HIP”).  This is one of the five features of Host Integration Server (HIS).  Starting with the BizTalk 2009 release, HIS is no longer sold separately, and can only be obtained along with a BizTalk license. HIP – Host Initiated Processing […]

I made some interesting discoveries today. We had a file from a client’s database administrator (DBA) that had a list of all the stored procs from a certain database. He was off today, so we were unsure how he created it. Using the open source (free) editor called NotePad++, we did a “find” on “Create […]

We have several deployment scripts that have to run on both 32-bit and 64-bit environments. Until now, we just modified the script with a “replace all’ command for the 64-bit, which had to use “C:Program Files (x86)” instead of the traditional “C:Program Files” directory. This was my first attempt: set BTDFProgFiles="%programfiles(x86)%" if %BTDFProgFiles%=="" set BTDFProgFiles="%programfiles%" […]

March 29, 2011 Orchestration Issue If you get this mysterious error in a BizTalk orchestration: Value cannot be null. Parameter name: val If you are running an orchestration, then a potential problem is that you tried to set a “distinguished field” to the value of NULL. How I hit this error today ? I had […]

I don’t think I ever even tried the left and right arrows in BizTalk Admin Console until this week.  A voice called to may saying “click me”, “click me”. BizTalk Admin console can be notoriously slow; sometimes I keep two of them open, one to restart host instances, and the other to deal with applications, […]

My client uses a non-standard SQL port number. So for example, when connecting in SSMS (SQL Server Management Studio), we type in “MyServer,1234” for the server name. This also works in connection strings (i.e. specify servername, then comma, then port number. I suppose if you were using a named instance, it would be “MyServer/MyInstance,1234”. But […]