Microsoft BizTalk Server
A family of Microsoft server products that support large-scale implementation management of enterprise application integration processes.
361 questions
How to fetch data from Sql server by Biztalk Server 2013 without using orchestration?
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(153.6, 35%, 24%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EKS%3C/text%3E%3C/svg%3E)
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
{count} votes
-
Colin Dijkgraaf 1,346 Reputation points2022-10-10T03:22:48.127+00:00 That example does use an Orchestration, but you can just leave that part out, and have the map in either the receive port or send port.
Sign in to comment