Duplicate Receive Location?

Home Page › Forums › BizTalk 2004 – BizTalk 2010 › Duplicate Receive Location?

Viewing 3 reply threads
  • Author
    Posts
    • July 28, 2010 at 5:07 AM #25420
      community-content

        Hello.

        I consume a stored procedure with a WCF SQL adapter. In the WCF SQL adapter I call the stored procedure with a parameter. Now I want to call the same stored procedure with another parameter.

        My question is, is it possible to call the stored procedure with diefferent parameter out of a WCF SQL adapter?

        If not, is it possible to duplicate the receive location where I can change the probperties of the sqlbindings?

        Or do I have to build a new project?

        Thanks for your help.

        Wolfgang

      • July 28, 2010 at 7:05 AM #25421
        community-content

          Ok, I build a new WCF SQL adapter and a new receive location and in the new sqlbindings I inserted another parameter.

          But I’m still interessted if someone knows if I can duplicate a receive location and change just the properties.

          Thanks

          Wolfgang   

        • July 28, 2010 at 8:48 AM #25423
          community-content

            Hi,

             

            You can duplicate the receive location with the following Step :

            • Export Bindings
            • Copy and Past the xml corresponding to the receive location
            • change the Name of the receivelocation
            • Import Bindings

            If you do like this, BizTalk must set an error because you use the same URI in two receive location. So you can add after you URI :?InboundId=MyParameterN

            Example :

            rloc1, uri : mssql://xxx.xx.xx.xxx/MyDatabase?InboundId=Rloc1
            rloc2, uri : mssql://xxx.xx.xx.xxx/MyDatabase?InboundId=Rloc2

            If you need to poll data in a receive location, I think it’s a good solution.

            Hope this answer help you!

             

            Regards

             

            • July 28, 2010 at 8:57 AM #25424
              community-content

                Hi Jeremie.

                Thanks a lot for your help …

                But as you said, I think for my application the better way is to build a new receive location without copying it. But it is good to know another way.

                Thanks

                Wolfgang

            • November 19, 2020 at 3:12 PM #50480
              biztalkgurus

                Lucky and Squash · Jeanne Birdsall · 9780060831509

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