| BizTalk Architect 2004-11-12, 7:48 am |
|
"news.microsoft.com" <pvilla@montevideo.com.uy> wrote in message
news:Ocd38EByEHA.3096@tk2msftngp13.phx.gbl...
>I have a Queue being listened by a Biztalk orchestration.
> Biztalk reads a message from MSMQ and after the orchestration it makes an
> Insert into a SQL Server database.
>
> Is it possible to make the hole process transactional ?
>
> I mean, if the Insert fails then then transaction makes a rollback that
> implies the message must be in the queue.
>
> thanks for your help
> Pablo.
>
I'm 99% certain that you cannot place the message back in the the automated,
structured way you mention.
What you could do is use a MSMQ trigger (w2k) to mediate for you, BUT... my
experiece with MSMQ triggers is that they are unstable and gum up the works.
Use with caution.
I am commenting on BTS 2000/2002, but I think this is also true for BTS
2004.
Isaac Ferreira
Application Architect
Certifed BizTalk developer
|