Re: BizTalk SQL adapter and the SQL 2005 XML datatype

You can review this page and play around with the large message fragment size, TransformThreshold, and large message threshold settings:

http://msdn.microsoft.com/en-us/library/aa560481.aspx