BizTalk Server Orchestration - How many messages in a orchestration instance

Author

How many messages in a orchestration instance

njhudson

2005-09-14, 5:52 pm

I ma having a problem retrieving a value from a database.

Bsaically I have built my own custom EDI maps. These do not use the
EDI adapter which means I need to create a way to store and increment
control number values. I do this by having the orchestration send a
message to a SQL server adapter which triggers a stored procedure.
Then the map retrieves the new value.

However, all of the files translated come out with the latest updated
value for the control number. For example, if I drop two files into
my pickup directory and the control number has a value of 20, then
both resulting EDI files have a control number of 22. I thought an
orchestration processed one message at a time. What am I missing and
how do I handle it?

Thanks,
Nathan