Geeks With Blogs
Ganesh Narayanan's BizTalk Hints MCTS

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

Posted on Thursday, September 3, 2009 9:07 AM | Back to top


Comments on this post: Dynamic SQL Port - New in Biztalk 2009

# re: Dynamic SQL Port - New in Biztalk 2009
Requesting Gravatar...
I believe the above reference would work well with BizTalk 2006 R2, once we install the Adpater Pack 2.0 on it ?

Please correct me if I'm assuming something here ?
Cheers - Zee
Left by Zeeshan on Feb 16, 2010 7:49 PM

Your comment:
 (will show your gravatar)


Copyright © Ganesh Narayanan | Powered by: GeeksWithBlogs.net