Changing the name of a stored procedure associated with a sql Adapter – BT06

Home Page › Forums › BizTalk 2004 – BizTalk 2010 › Changing the name of a stored procedure associated with a sql Adapter – BT06

Viewing 1 reply thread
  • Author
    Posts
    • January 29, 2007 at 10:13 AM #17464
      community-content

        I have an sqlAdapter that invokes a stored procedure.  I'd like to change the name of the stored procedure.  I thought I might edit the following in the schema file:

         <xs:appinfo>
              <msbtssql:sqlScript value="exec [gsproc_1101] @APPROVED_AMOUNT=&quot;1&quot;,…

         But just changing the stored procedure name gsproc_1101 to the new name of the stored procedure doesn't work.  What other points need to be manually changed in order for this to work?

         

      • January 29, 2007 at 10:23 AM #17465
        community-content

          You also need to change the element name in the schema:

          <root>
              <gsproc_1101>
                  <APPROVED_AMOUNT>…

              </gsproc_1101>
          </root>

          It is the element name which is used by the adapter to call the stored procedure

          • January 30, 2007 at 5:13 AM #17480
            community-content

              Yes that worked well.  I also had to change the map that used the sql Adapter schema and make sure that all links had the new name.  Since I also XLST that had to be changed also with the new name.

              thanks.

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