I have a scenario for using the Biztalk 2002 as a
transformation engine.
I will place a no of messages as a batch to a MessageQueue .I donot
know the no of messages in the batch design time.But i can specify the
starting/ending of a batch with a special type of message.I want
biztalk to start a transaction when it reads the StartBatch message and

read the next messages and  transform the message data  and store the
result to a Database table.It can commit the data when it encounters
the EndBatch message.If there is any error happens in between batch the

entire transaction has to be rolled back.i.e the messages have to be
placed back to the queue and db inserted records should be rolled
back.Can I able to do this using biztak 2002 ,If yes please say how  ?


Thanks in advance,

Regards,

Ram

[ Post a follow-up to this message ]