Greetings MJ,
You can do this using the mapping utility in BizTalk 2004. I think you
will find some siliarities in the following examples. You may find that
you  will need to devise a custom schema that your company will
initially transform all related inbound messages to in order to
standardize/reuse the various business processes/orchestrations that
are related to this type of data (Common Business Object)

The Looping functoid combines multiple records or fields in the source
schema into a single record in the destination schema.The following
link shows a Looping functoid used in a map to combine addresses
collected from two different surveys into a single master address list.
http://msdn.microsoft.com/library/d...
_map_nvsc.asp

This section briefly describes a map using the Table Looping and Table
Extractor functoids
http://msdn.microsoft.com/library/d...
_map_xami.asp

[ Post a follow-up to this message ]