Creating an XML document from SQL Table Data

Home Page Forums BizTalk 2004 – BizTalk 2010 Creating an XML document from SQL Table Data

Viewing 1 reply thread
  • Author
    Posts
    • #13207

      Hello

      I have an Orchestration that takes incoming XML data, processes it through a stored procedure and then writes resutant data ton SQL table. I need to create an XML document from that data.

      In Biztalk I know how to put data into SQL from XML – but How do I get XML from SQL using Biztalk?

      Regards
      JMan

    • #13208

      If this is part of the same process you can map either the incoming Xml data or the SQL data that you write to SQL into any format you wish and send it anywhere.

      If this is not the same process then you can use the SQL Receive Adapter with either a Select statement or store procedure. The SQL Receive adapter polls the database at an interval you specify.

Viewing 1 reply thread
  • The forum ‘BizTalk 2004 – BizTalk 2010’ is closed to new topics and replies.