Stored procedure to SQL adapter without parameter

Home Page › Forums › BizTalk 2004 – BizTalk 2010 › Stored procedure to SQL adapter without parameter

Viewing 1 reply thread
  • Author
    Posts
    • December 6, 2005 at 6:34 AM #12495
      community-content

        Hi,

        1] We want to call out stored procedure through SQL Adapter without any parameters. Is it possible to call out the same?

        How can we invoke that stored procedure without any parameters?

        2] We want [b:b09bda5543]\”Biztalk web service publishing wizard\”[/b:b09bda5543] on virtual server which do not have development environment installed on it? So could you tell me what is platform requiremnts of Biztalk web service publishing wizard?

        Thanks in advance

        Sam

      • December 7, 2005 at 5:21 PM #12496
        community-content

          1. I don’t know if you can do this. I would go about this using .net code inside an Orchestration to call your Stored Procedure. The adapter is really intended to bring data into BizTalk and send data to SQL.

          2. As far as I know, you need the ide to run the wizard. It creates the asp.net projects for you and set them up in iis. You might want to look at this: http://www.masteringbiztalk.com/blogs/jon/PermaLink,guid,3998ad88-372b-4daa-8544-c32cda32c922.aspx

          Hope this helps.

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