Home Page › Forums › BizTalk 2004 – BizTalk 2010 › sqladapter › sqladapter
December 30, 2005 at 2:18 AM
#12552
Your approach seems fine. The key is to break up the message into single messages before you process them.
You could also look at using a Convoy to process the received messages one at a time. This, along with an Envelope on the Receive Pipeline to break up the message can be a good solution without an atomic scope.
I have several samples of Convoys on this site and well as a lot information on de batching.