Monthly Archives: June 2009

Installing BizTalk ESB Toolkit 2.0

Microsoft BizTalk ESB Toolkit 2.0 (formerly known as ESB Guidance 2.0) is out. I installed it, together with the ESB Management Portal, today on a Windows Server 2008 32-bit virtual machine using the following procedure: Install BizTalk ESB Toolkit 2.0-<CPU>.msi. … Continue reading

Posted in BizTalk | 1 Comment

Connection String for DB2 on Windows

I had a lot of trouble with connecting to DB2 on Windows. I thought it was hard to figure out the right connection string, and there is also a bug that led me on the wrong track. I had DB2 … Continue reading

Posted in BizTalk | Leave a comment

Host Integration Server 2009 vs. BizTalk Server 2009 Adapters for Host Systems 2.0

I recently did a proof of concept where one part was connectivity with DB2. I had BizTalk Server 2009 developer edition installed, and thought that I would get the DB2 adapter by installing Host Integration Server 2009. Wrong! After a … Continue reading

Posted in BizTalk | Leave a comment

XPath sum in BRE becomes type double

Using the Business Rules Engine (BRE), you can use XPath functions like sum in vocabulary definitions. For example, I had a vocabulary definition where I wanted to calculate the total tax from an EDIFACT invoice. I had the following definition: … Continue reading

Posted in BizTalk | Leave a comment

Schema validation inside orchestration

BizTalk can do XML schema validation using the XML disassembler pipeline component. But I wanted to the same thing in orchestration to have better control of the error handling and produce better error messages. My solution was to write a … Continue reading

Posted in Uncategorized | Leave a comment

Setting e-mail text body in BizTalk

If you want to programmatically set the e-mail text body in a BizTalk orchestration, you must also set the content. Example: NotificationOutgoing(SMTP.EmailBodyText) = bodyText;NotificationOutgoing(SMTP.EmailBodyTextCharset) = “UTF-8”;

Posted in BizTalk | Leave a comment

Internal Error – cannot open database “BAMStarSchema” when trying to deploy a BAM activity

When I tried to install ESB Guidance 2.0 CTP2 exception handling, I got the following error from the BAM deployment part of the installation script: Deploying Activity… Done. Deploying View… ERROR: The BAM deployment failed. Internal error: The operation terminated … Continue reading

Posted in BizTalk | 5 Comments