Archive for March, 2012

Richard Dingwall offers a simple explanation of how to use the SQL Server’s FOR XML in PATH mode here: http://richarddingwall.name/2008/08/26/nested-xml-results-from-sql-server-with-for-xml-path/

Advertisements

Thiago Almeida has written a nice article which details how to call a stored procedure multiple times without using a loop shape here: http://connectedthoughts.wordpress.com/2008/09/09/multiple-stored-procedure-calls-using-the-biztalk-sql-adapter-without-a-loop-shape/

Richard Seroter has written an excellent article which describes the behavior of resuming a suspended message in Biztalk Server at http://seroter.wordpress.com/2007/01/02/orchestration-handling-of-suspended-messages/

Stephen Kaufman – 24 Oct 2004 11:14 PM – How to get the source file name in a pipeline component:

In previous entries I have shown how to access Pipeline Context items. There are a number of ‘built in’ promoted properties that provide important information. There are different items for the receive and send pipelines.

The 14 receive pipeline items are #including the associated namespace#:

1. ReceivedFileName #http://schemas.microsoft.com/BizTalk/2003/file-properties#

2. InboundTransportLocation #http://schemas.microsoft.com/BizTalk/2003/system-properties#

3. InterchangeID #http://schemas.microsoft.com/BizTalk/2003/system-properties#

4. ReceivePortID #http://schemas.microsoft.com/BizTalk/2003/system-properties#

5. ReceivePortName #http://schemas.microsoft.com/BizTalk/2003/system-properties#

6. WasSolicitResponse #http://schemas.microsoft.com/BizTalk/2003/system-properties#

7. AuthenticationRequiredOnReceivePort #http://schemas.microsoft.com/BizTalk/2003/system-properties#

8. InboundTransportType #http://schemas.microsoft.com/BizTalk/2003/system-properties#

9. LRPMsgBodyTracking #http://schemas.microsoft.com/BizTalk/2003/system-properties#

10. MessageExchangePattern (http://schemas.microsoft.com/BizTalk/2003/system-properties)

11. PortName (http://schemas.microsoft.com/BizTalk/2003/messagetracking-properties)

via How to get the source file name in a pipeline component – Stephen Kaufman’s WebLog – Site Home – MSDN Blogs.

Auto-GAC your BizTalk Helper Classes with Post Build Events

Working with .net helper classes in BizTalk Server is a common occurance.

It can sometimes be easy to forget to GAC the latest version of the code when you go to test the solution on your local development box. But using a simple Post Build Event, you can have your code automatically put in the GAC for you.

Adding a post build event is easy. Just go to the project properties of your helper class and select Build Events.

Enter the following under Post Build Event:

“C:\Program Files\Microsoft Visual Studio 8\SDK\v2.0\Bin\gacutil.exe” /i $#TargetPath#

Now when you build your .net code your dll will be GACed for you.

via Auto-GAC your BizTalk Helper Classes with Post Build Events.

Fabio Marini has created a nice template for creating multi-part maps in Biztalk 2010 which can be found here: Multipart Map Template.

Atin Agarwal has an excellent post regarding ‘Inserting parent child records with Identity column using WCF-SQL Adapter in one transaction’.

via Inserting parent child records with Identity column using WCF-SQL Adapter in one transaction – One Blog for Biztalk Engineers – Site Home – MSDN Blogs.