|
Home > Archive > BizTalk Server Orchestration > September 2004 > DTC--transaction in biztalk 2004
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
DTC--transaction in biztalk 2004
|
|
|
| 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
| |
| Andres Felipe Arguello 2004-09-22, 9:56 pm |
| 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
| |
| Shaheer Abubucker 2004-09-22, 9:56 pm |
| 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
|
|
|
|
|
|
|
|