Archive
Author: ninithepug
-

SQL script to undeploy rules/vocabularies
Just to repost an entry to undeploy BRE rule a few years back in my another blog. USE [BizTalkRuleEngineDb]GO/****** Object: StoredProcedure [dbo].[usp_un_rule] Script Date: 04/27/2009 22:34:05 ******/SET ANSI_NULLS…
-

Connect to SAP load balancing server
It turns out SAP is leveraging the same concept as BizTalk load balancing concept, with a message server and buntch of application servers. The connection should be setup…
-

How to trick BizTalk process all trigger events for a domain
Problem is if you come up with a custom trigger event within a domain, i.e. ADT_ZZZ, the accelerator requires not only update the MSH schema, but also create…
-

What’s inside HL72fDasm Component
// if set passthrough to true, then this disassembler is a passthrough componentobject obj2 = inMsg.Context.Read(“PassThru”, “http://HL7Schemas.HeaderPropertySchema”);if ((obj2 != null) && ((bool) obj2)) { this.mCalledFirstTime = false; this.mMessageList[0]…
-

HL7 Notes (3)
BTAHL7 Flat File Assemble Pipeline Component – single message a) read value from MSH5.1, 5.2 and 5.3, comnbine them together as destination party b) read message send port…
-

HL7 Notes (2)
So working with HL7 is not that steep learning curve. Problem is there is lot to remember, by that I mean lots of table enumerations, data types etc.…
-

HL7 Notes (1)
DASM can be utilized inside of any custom pipeline, so you are free to create pre- and post-processing on the message as desired. (so we can add custom…
-

Deployment Framework
The BizTalk Deployment Framework (BTDF) on codeplex makes me both pain and excitement. The pain being lack of information and the poor documentation, the excitement being the power…
-

Edit DBQueryStep to enable multiple rows return
By default, the DBQueryStep only looks for first row, in which case it will cause problem in multiple rows result. I slightly changed the code in BizUnit to…
-

SAP adapter RFC SDK dll
This drove me crazy on Friday, as it is not enough documented both by Microsoft and SAP. To make things worse, access SAP market place is not as…