Archive for September, 2009

Dynamic SQL Port – New in Biztalk 2009

September 3rd, 2009  |  Published in BizTalk Tips

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.ResponseDocumentRootElementName)

(SQL.DocumentTargetNamespace)

(SQL.ConnectionString)

Configuring these properties, together with

(Microsoft.XLANGs.BaseTypes.Address)=”SQL://” +Servername/ + Databasename/

creates a fully functional Dynamic SQL Adapter.

For the WCF SQL adapter, follow the steps in the link:

http://msdn.microsoft.com/en-us/library/dd788439(BTS.10).aspx