Hi I have an orchestration A which parses a flat file and does some stuff and invokes orchestration(s) B (for each record in the flat file one orchestration B instance). all these instances have some other processing to be done and finally invokes orchestration C which have to send some details with some details to a HTTP send port.
Here is the problem.
orchestration C should be called only once for the last instance of orchestration B i.e., after all the orchestration B instances have finished with their stuff. I tried to achieve this by updating a database table to indicate whether or not orchestration C can be triggered. Some how BizTalk is running these orchestrations so fast that all orchestration B instances end up triggering orchestration C. The database check is done in a Atomic scope in orchestration B.
How do i make sure only instance of the orchestration C is run?
Thanks in advance for any suggestions