Hello:

I have an orchestration that I am going to use to insert database records
coming in from another system.
In a custom pipeline, I split the incoming database records into seperate
messages by tables.  So I have one big file coming in, and then for each
table I generate 1 message.  NO problem.

The question I have is that each table has a different schema, and I need
someway to identify to the orchestration which schema is coming in, in order
to pass it along to the correct SQL Table, and I am not real sure how to
accomplish this.  It seems that I can only receive one message type into the
orchestration, but I am going to have about fourteen or fifteen.

What comes to mind is some type of generic message that I can downchain to
the correct message type in the orchestration based on some data, then pass
that newly constructed message onto the database insert, but I don't know ho
w
to do that, nor if that is the 'right' way to solve the problem.

any help is greatly appreciated
Thanks!

[ Post a follow-up to this message ]

Look at the blogs below to see an example of how to receive type agnostic
messages in your orchestration:

http://blogs.msdn.com/scottwoo/arch.../02/147120.aspx
http://www.geekswithblogs.net/sthom...08/10/9557.aspx

This posting is provided "AS IS" with no warranties, and confers no rights.

EBusiness Server Team
--------------------
| >>Thread-Topic: Receiving messages into orchestration from custom pipeline
| >>thread-index: AcSyJb/zyO9y938DRnG2a7+7Mc3IOA==
| >>X-WBNR-Posting-Host: 216.54.107.91
| >>From: "examnotes"
<JamesLongstreet@discussions.microsoft.com>
| >>Subject: Receiving messages into orchestration from custom pipeline
| >>Date: Thu, 14 Oct 2004 12:41:07 -0700
| >>Lines: 22
| >>Message-ID: <55DDF111-29CF-44EE-9163-5D571C35CC5C@microsoft.com>
| >>MIME-Version: 1.0
| >>Content-Type: text/plain;
| >>	charset="Utf-8"
| >>Content-Transfer-Encoding: 7bit
| >>X-Newsreader: Microsoft CDO for Windows 2000
| >>Content-Class: urn:content-classes:message
| >>Importance: normal
| >>Priority: normal
| >>X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.0
| >>Newsgroups: microsoft.public.biztalk.orchestration
| >>NNTP-Posting-Host: TK2MSFTNGXA03.phx.gbl 10.40.1.29
| >>Path: cpmsftngxa10.phx.gbl!TK2MSFTNGXA03.phx.gbl
| >>Xref: cpmsftngxa10.phx.gbl microsoft.public.biztalk.orchestration:8682
| >>X-Tomcat-NG: microsoft.public.biztalk.orchestration
| >>
| >>Hello:
| >>
| >>I have an orchestration that I am going to use to insert database
records
| >>coming in from another system.
| >>In a custom pipeline, I split the incoming database records into
seperate
| >>messages by tables.  So I have one big file coming in, and then for
each
| >>table I generate 1 message.  NO problem.
| >>
| >>The question I have is that each table has a different schema, and I
need
| >>someway to identify to the orchestration which schema is coming in, in
order
| >>to pass it along to the correct SQL Table, and I am not real sure how
to
| >>accomplish this.  It seems that I can only receive one message type
into the
| >>orchestration, but I am going to have about fourteen or fifteen.
| >>
| >>What comes to mind is some type of generic message that I can downchain
to
| >>the correct message type in the orchestration based on some data, then
pass
| >>that newly constructed message onto the database insert, but I don't
know how
| >>to do that, nor if that is the 'right' way to solve the problem.
| >>
| >>any help is greatly appreciated
| >>Thanks!
| >>
| >>

[ Post a follow-up to this message ]