|
Home > Archive > BizTalk Server Orchestration > November 2004 > Assigning value to a set of "records"
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
Assigning value to a set of "records"
|
|
| norgie 2004-11-15, 7:46 am |
| Hi.
Is it possible in an orchestration to assign a value to a specific
(promoted) field for every "record" in a collection before it is sent to e.g.
a DB.
My orchestration works as follows:
1) Receive flat file
2) Map flat file to updategram
3) Send all records in updategram to DB using SqlAdapter
4) Call Web Service to trigger post insert processing
What I would like to do is to call a WebService to get the next batch number
(got that to work) and assign the batch number to each "record" in the
updategram. This should take place between step 2 and 3 above. Is this
possible? If so, what do I do to make it work?
Would getting the next batch number while in the map be a better solution?
If so, can the map be configured so that it only calls the Database lookup
functoid once and not for every record it is processing?
TIA
--norgie
| |
| Matt Meleski 2004-11-15, 5:49 pm |
| Norgie,
I have an example of assigning doing this, please see :
http://objectsharp.com/Blogs/matt/a...11/09/1009.aspx
In example 4) I am creating the extra nodes, using a loop shape
and xpath, to assign the values.
Matt
"norgie" wrote:
> Hi.
>
> Is it possible in an orchestration to assign a value to a specific
> (promoted) field for every "record" in a collection before it is sent to e.g.
> a DB.
>
> My orchestration works as follows:
>
> 1) Receive flat file
> 2) Map flat file to updategram
> 3) Send all records in updategram to DB using SqlAdapter
> 4) Call Web Service to trigger post insert processing
>
> What I would like to do is to call a WebService to get the next batch number
> (got that to work) and assign the batch number to each "record" in the
> updategram. This should take place between step 2 and 3 above. Is this
> possible? If so, what do I do to make it work?
>
> Would getting the next batch number while in the map be a better solution?
> If so, can the map be configured so that it only calls the Database lookup
> functoid once and not for every record it is processing?
>
> TIA
>
> --norgie
|
|
|
|
|