How to Update records through SQL Adapter

Home Page › Forums › BizTalk 2004 – BizTalk 2010 › How to Update records through SQL Adapter

Viewing 1 reply thread
  • Author
    Posts
    • May 11, 2006 at 7:24 AM #13555
      community-content

        You have inserted record in database with stored procedure, now in order to update records select data from the same procedure which you want as a information of XML file by giving ‘for xml data, elements’. Then u will get xml file as output.

        now write another Stored procedure who has this xml data as a input parameter and update records according to it. Add a new SQL adapter to your Orch.

        MAp the response of first SQL adapter to a request of another SQL adapter. It will work definitely.

      • May 11, 2006 at 4:42 PM #13556
        community-content

          You should take a look at Todd Uhl’s SQL White Paper. I think it covers this with a sample.

          Should be able to find it here: http://msdn.microsoft.com/library/default.asp?url=/library/en-us/BTS_2004WP/html/90a5261b-a220-41bf-bf7f-fd759239242c.asp

          • May 11, 2006 at 5:39 AM #13557
            community-content

              Hey i want to receive an XML file and update some information on the basis of that file in the SQL database table. can any body give me some scenario.
              i have inserted records with this procedure by creating a schema through Add genarated items and selected Insert in the UpdateGram. i works fine . but plz tell me how can i UPdate a record with this method.

              Regards,
              Jan

              • May 11, 2006 at 9:00 AM #13558
                community-content

                  Thanx SAM , but i have to do it with UpdateGram and not by the StoredProcedure. i also inserted the data through UpdateGram’s Insert option and not by the StoredProcedure. so how can i update usind the UpdateGram’s UPDATE option. any suggestions??

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