Write data to SQL Server directly from BizTalk or use external service?
- by dlongest
An external source will be sending us XML data that BizTalk will pick up and transform into an internal schema. We need this data to be loaded into a SQL Server database as we're going to expose some of the data to our web front-end via a custom WCF service.
The question is: what is the recommended approach for doing something like this? …