- This topic has 1 reply, 1 voice, and was last updated 8 years, 3 months ago by
.
-
Posts
-
-
Hello,
Let’s say I have tables A, B, C in a database. I want a BizTalk
Orchestration to insert values to A, then B, then C. But if the insert in C
failes, the previous two insert operations would have to roll back.I am trying (unsuccesfully) to do this in the orchestration:
[img:08e3eb8b28]http://msdn.microsoft.com/library/en-us/BTS_2004WP/local/Local_-678347877_bts_wp_trans_fig6.gif[/img:08e3eb8b28]
The picture was taken from the following site:
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/BTS_2004WP/html/ed17b4fc-ddc1-4a41-a134-7d11b2ea3a87.aspHowever, I cannot figure out how to connect the different send shapes to a
single send port. Can anyone explain to me how this was accomplished?Thanks in advance for the help!
— Steve
-
Unless you had all three SQL updates in a single Stored Procedure, I think the easiest way to accomplish a roll back would be to use Enterprise Servers inside .net code in an Atomic Transaction rather then the SQL Adapter.
In the above picture, I think you need to manually call the compensation blocks of the successful transactions. So under this you’d have logic to check the status of the transactions – I think.
-
- The forum ‘BizTalk 2004 – BizTalk 2010’ is closed to new topics and replies.