BizTalk Server Orchestration - SQL Adapter Problem

Author

SQL Adapter Problem

Sents

2005-01-19, 7:47 am

I have a stored procedure.

Select * from orginal table if <<condition>>
If exists
Insert into duplicate table
else
insert into orginal table.

I am calling this stored procedure from Orchestration thru SQL adapter.

If i send record one by one with certain time interval it inserts properly.
If i drop mulitple records(which has duplicate), then it is inserts
duplicate record in oringal table. B'cose it is executing simultaneously
(with multiple instance of orch). I have put atomic scope with serilizable in
send shape . But still it is doing in the same way. Any thoughts on this.

Regards
Senthil