A big gotcha

I installed the "Microsoft Biztalk 2010 Accelerator for SWIFT" (A4SWIFT) and the "Microsoft Biztalk Accelerator for SWIFT 2010 Message Pack" on my computer. In my work I need to research the SWIFT schemas and such. I was trying to open up the SWIFT header schema that is inside the Microsoft.Solutions.FinancialServices.SWIFT.RuntimeSchemas assembly. However I keep getting this error: Could not load type 'Microsoft.Solutions.FinancialServices.SWIFT.RuntimeSchemas.HeaderSchema' from assembly 'Microsoft.Solutions.FinancialServices.SWIFT.RuntimeSchemas, Version=3.2.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35'. The problem is that there are two assemblies with the same file name and version number! The one creating the error is from A4SWIFT. The correct one is in the message pack directory. Note that the namespace name has different: A4SWIFT: Microsoft.Solutions.FinancialServices.SWIFT.RuntimeSchemas.HeaderSchema A4SWIFT Message Pack: SWIFTSchemas.SWIFTHeader Confusing as hell. No idea why they left an obsolete assembly around.

using Biztalk script functoid

I have been trying to use Biztalk maps to create xsl transforms. The biggest challenge seems to be finding resources that talk about its capabilities and limitations. Here is my little contribution.

My transform involves a lot of repeating structures. In particiular a bunch of addresses attached to different entities that needs to be mapped to another address structure.

xxx
yyy
www
...



...

...
...



...


In some cases the address entries are blanks but the destination does not allow blanks so the nodes have to be skipped.

Most of these tasks can be done with various functoids. But if you have to repeat a good few times the biztalk map gets hairy.

So my solution is to use the scripting functoid and write an xslt template. Luckily every has an id so I can use that as a parameter. The other parameter would be the node (a, b, c, or d) so that I can construct the xpath inside my template. Then it's normal xsl stuff and you can control your output.

I can construct an example if there is interest.

SQLserver 2008 R2 Management Studio

Awesome...

invalid license data. reinstall is required

I have Vista 64 SP2 and Visual Studio 2008 SP1. Monday morning I got this error message when I try to start Visual Studio. MSDN recommends reinstalling Visual Studio.

Luckily the technical support guy reminded to reboot the computer first. The problem goes away.