Using XML Explicit

Home Page › Forums › BizTalk 2004 – BizTalk 2010 › Using XML Explicit

Viewing 1 reply thread
  • Author
    Posts
    • June 14, 2006 at 3:15 AM #13848
      community-content

        Hello

        I am using an SQL adapter to extract data from a Stored Procedure. Ordinarily I use ‘select * from myTable for XML RAW, XMLDATA’
        But in this instance the SP was written by someone else and their code uses this syntax ‘select * from myTable for XML EXPLICIT, XMLDATA’

        Howver this gives me problems when I try to incorporate it into my Orchestration.

        Ant ideas welcome.

        Regards
        JMan

      • June 14, 2006 at 3:14 PM #13849
        community-content

          I think the Explicit option is unsupported by the bulit-in SQL Adapter, we needed it a time or two and never got it to work. Maybe you could wrap the stored proc with a C# program?

          See this site for some possible \”Hacks\”.

          http://objectsharp.com/blogs/matt/archive/2005/03/22/1560.aspx

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