BizTalk 2010 -Free Developer Edition

I am super excited about this. A freely down-loadable version of BizTalk 2010 available here.
More information on msdn blog.

Table Looping and Table Extractor Functoid in BizTalk

In my recent project I had two requirements for mapping
1.    Map fixed number of elements from source to repeating elements in the destination message.
2.    And Map only if  the value in one of the element exists

Solution: Table Looping and Table Extractor Functoid

Here is a good blog post on using Table Looping and Table Extractor functoid that I referred.
http://hestia.typepad.com/flatlander/2007/01/mapping_fixed_e.html

In order to satisfy the requirement number 2 above I used the Not Equal functoid and connected it to the table looping functoid. Under Configure Table Looping Grid used the output from Not Equal functoid as Column 1 and checked the gated checkbox.

The configure table looping grid looks like below

Getting Received File Name in BizTalk

I wanted to store the name of the file that was received at the Receive port in BizTalk.
So, I went ahead and used the following in the expression shape to get the filename from the message property:

strFileName= MyMessage((FILE.ReceivedFileName)

But the property above returns the filename with complete file path.

And thats where System.IO namespace comes into the picture.
The handy GetFileName method below does the parsing for you, and returns the filename sweet!

strFileName = System.IO.Path.GetFileName(MyMessage(FILE.ReceivedFileName))

Happy BizTalking!