Hi all,
is it possible to have  DTC/COM+ style transaction in biztalk 2004.

so i want to put two send shape in a atomic scope ....each of these
send shape will try to insert recods in to sql servers using biztalk
sql adapter.
actual data insertion will be done using sqlStoredProcedures.

if any one of these stored proc returns rollback, complete transaction
has to be rolled back..which includes both send shapes.

is it possible to do this in biztalk 2004 ?how?

thanks
siddharth

[ Post a follow-up to this message ]

Maybe this article can answer the question:
http://geekswithblogs.net/cyoung/ar...ansactions.aspx

"sidd" <siddharthkhare@hotmail.com> wrote in message
news:af96a2d7.0409152051.57b78130@posting.google.com...
> Hi all,
> is it possible to have  DTC/COM+ style transaction in biztalk 2004.
>
> so i want to put two send shape in a atomic scope ....each of these
> send shape will try to insert recods in to sql servers using biztalk
> sql adapter.
> actual data insertion will be done using sqlStoredProcedures.
>
> if any one of these stored proc returns rollback, complete transaction
> has to be rolled back..which includes both send shapes.
>
> is it possible to do this in biztalk 2004 ?how?
>
> thanks
> siddharth

[ Post a follow-up to this message ]

This is possible and that article should let you know how to do it.

Let us know if you still have questions.

Shaheer Abubucker
Microsoft Biztalk Server Team
This posting is provided "AS IS" with no warranties,and confers no rights.
Subscribe at
http://support.microsoft.com/defaul...msdn/nospam.asp
&SD=msdn


--------------------
| From: "Andres Felipe Arguello" <felipe.arguello@cenet.com>
|
| Maybe this article can answer the question:
| http://geekswithblogs.net/cyoung/ar...ansactions.aspx
|
| "sidd" <siddharthkhare@hotmail.com> wrote in message
| news:af96a2d7.0409152051.57b78130@posting.google.com...
| > Hi all,
| > is it possible to have  DTC/COM+ style transaction in biztalk 2004.
| >
| > so i want to put two send shape in a atomic scope ....each of these
| > send shape will try to insert recods in to sql servers using biztalk
| > sql adapter.
| > actual data insertion will be done using sqlStoredProcedures.
| >
| > if any one of these stored proc returns rollback, complete transaction
| > has to be rolled back..which includes both send shapes.
| >
| > is it possible to do this in biztalk 2004 ?how?
| >
| > thanks
| > siddharth
|
|
|

[ Post a follow-up to this message ]