Biz(Talk)2

Talk, talk and more talk about BizTalk

Unable to configure BAM Tools

While installing BizTalk 2010 in a multi-server configuration (one server for BizTalk, a different server for SQL), I received the following error while attempting to configure the BAM Archive database:

Microsoft SQL Server Data Transformation Services (DTS) 2008 with SP1 or higher for BAM Archiving is not installed on the local machine. Please install Microsoft SQL Server 2008 Integration Services. Could not load file or assembly

Additional information:

Could not load file or ¬†assembly ‘Microsoft.SqlServer.ManagedDts, Version=10.0.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91’ or one of its dependencies…

The wording of the suggested solution takes a too literal approach. Whilst installing Integration Services would solve the problem, only the actual DLL library ‘Microsoft.SqlServer.ManagedDTS‘ needs to be installed.

This can be done by performing an install from the Sql Server installation media, but choosing to install only the following:

  • – Management Tools – Basic
    • – Management Tools – Complete

It should now be possible to complete the configuration successfully.

February 14, 2013 Posted by | BAM, BizTalk | , | Leave a comment

Reminder post: How to deploy BAM activity and tracking definitons

So that I don’t have to Google next time I forget what I need to enter for BAM Activity and Tracking:

bm.exe deploy-all -DefinitionFile:"c:\full\path\to\activity-definition.xml"

bttdeploy.exe "c:\full\path\to\TrackingProfile.btt"

Both of these executables can be found in C:\Program Files [(x86)]\Microsoft BizTalk Server 2006\Tracking

June 11, 2010 Posted by | BAM, BizTalk | Leave a comment