I started doing some prototype using ESB Toolkit 2.0 Exception management framework and encountered the following exception when FaultMessage was transmitted to the Exception Management database via the generic ALL.Exceptions SQL send port under Microsoft.Practices.ESB application.
The adapter failed to transmit message going to send port “ALL.Exceptions” with URL “SQL://(local)/EsbExceptionDb/”. It will be retransmitted after the retry interval specified for this Send Port. Details:”Could not load file or assembly ‘Microsoft.Data.SqlXml, Version=10.0.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91′ or one of its dependencies. The system cannot find the file specified.”.
Looking at the GAC, there were couple of Assemblies with the name Microsoft.Data.SqlXml with version number 3.* and 9.*. But in our case its looking for 10.*. Doing some quick search revealed the dll is part of SQLXML 4.0 SP1, download and installation of SQLXML 4.0 SP1 (which is part of Microsoft SQL Server 2008 Feature Pack, October 2008) from the following link resolved the issue.