Lesson learned, Use command line from http://blogs.msdn.com/biztalkbre/archive/2007/02/16/sample-deploying-business-rules-programmatically.aspx to export vocabularies and rules to different files. Add this to Buildxxx.msi: ..\..\References\DeployRules /e /v:SharedInterfaceBroker.1.0 .\BRE_Vocabulary.xml..\..\References\DeployRules /e /p .\BRE_Policy.xml In deployment file turn IncludeVocabAndRules to true add entries to files extracted from step 1, <RuleVocabularies Include=”BRE_Vocabulary.xml”>   <LocationPath>.\</LocationPath> </RuleVocabularies> <RulePolicies Include=”BRE_Policy.xml”>   <LocationPath>.\</LocationPath> </RulePolicies>

This is for connecting SharePoint Foundation 2010 from BizTalk 2010, after deploying the adapter web service on the SharePoint server, adjust the TPM registry setting in the BizTalk server, my BizTalk server keep complaining although I confirmed many times the BizTalk host instance account is one of the group members. ‘The Windows SharePoint Services adapter […]

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 ONGOSET QUOTED_IDENTIFIER ONGO Create Procedure [dbo].[usp_un_rule](@rulesetName varchar(255),@verMajor int,@verMinor int)AsBeginDECLARE @RuleSetID intSELECT @RuleSetID = nRuleSetIDFROM RE_RulesetWHERE strName=@rulesetName AND nMajor=@verMajor AND nMinor=@verMinor UPDATE RE_RulesetSET nStatus = 0   WHERE nRuleSetID […]