I am using Biztalk 2000/2002. I have created a custom preprocessor that talk
s
to the SQL database.  I am using MSMQ Receive function that is configured
with the preprocessor.

Normally if there is a failure in the preprocessing component, messages are
rolled back to the MSMQ queue.

The problem I am facing is, messages are commited and rolled back to the
Queue in batches and proprocessing component processes one message at a time
.
As I have observed, once all the messages in the batch( Batch size varies
from time to time) are preprocessed, they are written to the work queue.

So, I want to have the pre-processing component to be transactional and
enlist in the root transaction started by the Server.

I have tried to install the component in COM+ (Transaction- DISABLED) and it
works normally (Ofcourse with the above issue). If I change its TRANSACTION
attribute to (SUPPORTS), the messages get stuck in the Work Queue. No error
whatsoever and I feel the messages are not commited to the work queue.

Can any of the Biztalk Gurus help me on this.

Thanks in Advance.

[ Post a follow-up to this message ]