Hi All,
I have one orchestration and following is the design .
1. Receive Item XML File.
2. Process on Item File
3. Insert Item file records into SQL Server ( Recoreds would be 3000 to 4000)
4. Create new XML Message.
5. Using newly created XML call SQL another procedure(ProUpdateItem) which update above Item table.
I have desing orchestration transaction type is NONE.
Problem: When orchestration start inserting record in to Item file Orchestration start another thread which ll start executing ProUpdateItem procedure.
My system want to execute both send port sequentially, not simultaneously.
Note: We have 2 different environment 1 is development (BizTalk Standard edition ) and 2 production( Enterprise edition).
Above both send port are executing sequentially in development environment
While in production both send port execute simultaneously.
Can you please help me to solve my problem?
I appreciate your early support.
Regards,
– Dhaval M.