How to fetch data from Sql server by Biztalk Server 2013 without using orchestration?

Kush Singh 1 Reputation point

I want to fetch data from Sql server into a XML file by Biztalk without using Orchestration.

I have created a stored procedure for selecting Top 10 rows. Now, how to generate schema sql schema, map the response to created schema , and how ports(specially creation of receive location), set the interval for generating XML files.

Kindly help me in this

Microsoft BizTalk Server
Microsoft BizTalk Server
A family of Microsoft server products that support large-scale implementation management of enterprise application integration processes.
349 questions
{count} votes