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 […]
As you are well aware, all BizTalk programs must reside in the GAC. Many of use the “shell extension” to drag and drop programs to the GAC. But BEWARE, this tool is gone in .NET 4.0. See here for the Microsoft Official Statement: https://msdn.microsoft.com/en-us/library/vstudio/34149zk3%28v=vs.100%29.aspx Former link was moved by MSDN: http://msdn.microsoft.com/en-us/library/34149zk3.aspx “Beginning with the .NET […]
We recently learned that when you have MSMQ clustered, you cannot go to the normal “Manage Computer” to manage the queue. Instead, you have to run a special utility: <pre> MMCV –s YourMSMQClusterName </pre> The above utility can be downloaded from Microsoft.