Until the days of Biztalk 2006R2, the SQL Port was Static only and did not support dynamic ports. BizTalk 2009 fully supports Dynamic SQL Ports, both for the regular out-of-the-box SQL Adapter and the new WCF SQL adapter. For the regular SQL Adapter (which is being deprecated by microsoft), three new Message Context properties are available: (SQL.ResponseDocumentRootEl... ......