This project contains sample code for BizTalk Server demonstrating how to debatch messages received via a SQL "select" statement.
1. Resultset containing multiple rows (Firstname, Lastname) is retrieved from SQL table using simple SELECT statement, and submitted as a single message.
2. Message is split (debatched) into multiple individual messages within receive pipeline, each of which contains a single Firstname, Lastname pair.
3. Orchestration subscribes to individual messages, splits out firstname and lastname fields into separate messages.
4. Orchestration INSERTs firstname into one table and lastname into another.
The result is that all the firstnames end up in one table and all the lastnames end up in another.
This project relates to a blog post back in 2005 -