I am currently working on a project which include Biztalk 2004. The
project aims at gathering data from several databases (both via select
statements and stored procedures) as well as databases.
This data will then be used by the Biztalk Rule engine to determine an
outcome based on all this data.

Here is the flow broken in to pseudo-code.

1. Get a list of rows from a database (called: "DB1")
via an SQLAdapter ("SQLAdapter1") which contains a commond ID
2. Disassembling this result set using the SQL Adapter and schema
envelope so we get seperate messages which we can process one
by one (ID by ID).
3. Call SQLAdapter2 which accesses another database (called: "DB2").
SQLAdapter2 in turn calls a stored procedure which returns data
based on the common ID found in step 1/2.

How do you map the promoted property of an message ("commonID")
to this stored procedure parameter?


Thanks in advance
Ken

[ Post a follow-up to this message ]