How i cant insert the XML File into Database.

Home Page › Forums › BizTalk 2004 – BizTalk 2010 › How i cant insert the XML File into Database.

Viewing 1 reply thread
  • Author
    Posts
    • February 23, 2006 at 7:36 PM #12972
      community-content

        Hi, my question is:

        How i cant Insert the message ( XML file ) into the sql database?

      • February 23, 2006 at 10:34 PM #12973
        community-content

          Contents of that file with SQL adapter otherwise convert file into string and insert into database … 🙂

          • February 23, 2006 at 10:35 PM #12974
            community-content

              I depends on how you wish to store it.

              Do you want the individual field values to be mapped to columns, do you just want the entire message stored as an ntext/image or a combination of both?

              The easiest way is to use the SQL Send Adapter, with an updategram.
              Use the Add Adapter Metadata wizard to generate the schema.
              Create a map, from your message into the Sql updategram schema and send the updategram message to SQL.

              The SQL Send adapter will also use a stored proc, if the SQL insert/update logic is too complicated for an updategram.

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