Hi All,

I would like to debatch records from Typed Polling(WCF-SQL) and process them through orchestration.

Any suggestions please.

Hi,

Please check below useful article to resolve your issue,

Debatching Inbound Messages from BizTalk WCF SQL Adapter

Hi,

Please refer to the below mentioned article (a great article by Richard Seroter). It explains the complete scenario for debatching the records with TypedPolling WCF-SQL Adapter:

Debatching Inbound Messages from BizTalk WCF SQL Adapter

Please indicate "Mark as Answer" or "Mark as Helpful" if this post has answered the question

Rahul

• Proposed as answer by KK007[Kamlesh Kumar] 3 hours 16 minutes ago

Hi,

Please refer to the below mentioned article (a great article by Richard Seroter). It explains the complete scenario for debatching the records with TypedPolling WCF-SQL Adapter:

Debatching Inbound Messages from BizTalk WCF SQL Adapter

Please indicate "Mark as Answer" or "Mark as Helpful" if this post has answered the question

Rahul

• Proposed as answer by KK007[Kamlesh Kumar] Thursday, September 03, 2015 3:48 AM

Hi,

Please refer to the below mentioned article (a great article by Richard Seroter). It explains the complete scenario for debatching the records with TypedPolling WCF-SQL Adapter:

Debatching Inbound Messages from BizTalk WCF SQL Adapter

Please indicate "Mark as Answer" or "Mark as Helpful" if this post has answered the question

Rahul

• Proposed as answer by KK007[Kamlesh Kumar] Thursday, September 03, 2015 3:48 AM

This can be done using envelop schema and document schema. When you consume the sql stored procedure to generate the schemas you get two schemas..one we can use for envelop schema and another one as document schema. 

Cheers

Hi BTSUser,

I am not sure how complex your xml which your are getting from WCF-SQL.

Below links help you for all the scenarios.

- Envelop Level

Debatching Inbound Messages From WCF SQL Adapter in BizTalk & Typed polling Debatching

- Orchestration xpath / Calling receive pipeline

XPath Inside Orchestrations in BizTalk 2004

Calling A Receive Pipeline Inside an Orchestration in BizTalk 2006

Envelope Debatching and XPath Debatching Inside an Orchestration Biztalk Lab

Thanks, SMSVikasK

Hi BTSUser,

I am not sure how complex your xml which your are getting from WCF-SQL.

Below links help you for all the scenarios.

- Envelop Level

Debatching Inbound Messages From WCF SQL Adapter in BizTalk & Typed polling Debatching

- Orchestration xpath / Calling receive pipeline

XPath Inside Orchestrations in BizTalk 2004

Calling A Receive Pipeline Inside an Orchestration in BizTalk 2006

Envelope Debatching and XPath Debatching Inside an Orchestration Biztalk Lab

Thanks, SMSVikasK

• Proposed as answer by SMSVikasK 18 hours 43 minutes ago

Hi BTSUser,

I am not sure how complex your xml which your are getting from WCF-SQL.

Below links help you for all the scenarios.

- Envelop Level

Debatching Inbound Messages From WCF SQL Adapter in BizTalk & Typed polling Debatching

- Orchestration xpath / Calling receive pipeline

XPath Inside Orchestrations in BizTalk 2004

Calling A Receive Pipeline Inside an Orchestration in BizTalk 2006

Envelope Debatching and XPath Debatching Inside an Orchestration Biztalk Lab

Thanks, SMSVikasK

• Proposed as answer by SMSVikasK Thursday, September 03, 2015 12:21 PM

Hi BTSUser,

I am not sure how complex your xml which your are getting from WCF-SQL.

Below links help you for all the scenarios.

- Envelop Level

Debatching Inbound Messages From WCF SQL Adapter in BizTalk & Typed polling Debatching

- Orchestration xpath / Calling receive pipeline

XPath Inside Orchestrations in BizTalk 2004

Calling A Receive Pipeline Inside an Orchestration in BizTalk 2006

Envelope Debatching and XPath Debatching Inside an Orchestration Biztalk Lab

Thanks, SMSVikasK

• Proposed as answer by SMSVikasK Thursday, September 03, 2015 12:21 PM