Archive for the ‘Biztalk’ Category

It’s hard to find useful Biztalk-related templates for VisualStudio especially one as useful as this item template that Sandro Pereira brought to my attention for creating Custom Functoid Classes. Thanks Sandro.

Sandro Pereira BizTalk Blog

Following my previous post here’s another small contribution: Item Template for Visual Studio 2010: Custom BizTalk Functoid.

The New Functoid Class item template for Visual Studio 2010 allows you to create new Functoids for BizTalk Server 2010 without having to code the entire class and therefore allowing you to focus on what really matters, the functoid behavior. Just start a new Visual Studio C# library project and add a functoid class to start building your BizTalk Server 2010 custom Functoid.

How can I install the Item Template?

To use this item template in your C# library projects just download the project (Don´t unzip) and copy the compressed file to C:\Users\UserName\Documents\Visual Studio 2010\Templates\ItemTemplates\VisualC#.

Now when you add a new item to your project you will now see a new option: “Custom FunctoId Class”

Functoid-class

I really like to engage others people in this small projects, this time I was lucky to…

View original post 44 more words

Sandro Pereira posted the 6th of a series titled, ‘BizTalk Server: Basics principles of Maps’ which is probably the best explanation I have seen since I started working with Biztalk Server.

BizTalk Server: Basics principles of Maps – Testing and Validation of maps (at design time) (Part 6).

Here is a great explanation of how to use polling with the WCF-SQL adapter.

Richard Seroter's Architecture Musings

A few years back now (sheesh, that long already??) I wrote a post about debatching messages from the classic BizTalk SQL adapter.  Since that time, we’ve seen the release of the new and improved WCF-based SQL adapter.  You can read about the new adapter in a sample chapter of my book posted on the Packt Publishing website.  A blog reader recently asked me if I had ever demonstrated debatching via this new adapter, and to my surprise, I didn’t found anyone else documenting how to do this.  So, I guess I will.

First off, I created a database table to hold “Donation” records.  It holds donations given to a company, and I want those donations sent to downstream systems.  Because I may get more than one donation during a WCF-SQL adapter polling interval, I need to split the collection of retrieved records into individual records.

After creating a new…

View original post 571 more words

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/

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.