Store Procedure Runner

Home Page › Forums › BizTalk 2004 – BizTalk 2010 › Store Procedure Runner

Viewing 1 reply thread
  • Author
    Posts
    • January 16, 2009 at 8:56 PM #21517
      community-content

        Hi, im trying to use this functoid to execute a sp.

        I already set 2 parameters.

        1 Parameter – Connection String.

        D:\Runtime\Conn\EAI_Params.xml

        This is what you can find in this xml

        – <Root>
          <ConnStr Value=”Data Source=D095NWSQDES01\SQLBIZ;Initial Catalog=EAI_Params;Integrated Security=SSPI” />
          </Root>

         

        I tried .udl and also writing the hole conection string.

        Provider=SQLOLEDB.1;Integrated Security=SSPI;Persist Security Info=False;Initial Catalog=EAI_Params;Data Source=D095NWSQDES01\SQLBIZ

         

        2 Parameter – Name of my sp

        CF_Timer_Update

         

        And testing map using error extractor functoid ,i get this error.

        System.NullReferenceException: Object reference not set to an instance of an object. at Disco.BizTalk.Functoids.DBFunktoids.DBFunk.RunStoredProcedureEx(String connectionString, String storedProcedureName, String parameterNames, String[] parameters).

         

        Can someone help me out?

        Thanks

      • January 18, 2009 at 11:03 AM #21520
        community-content

          The error is pretty general.  I would try and debug the functoid.  If you are testing it in Visual Studio just attach to the exe and put a breakpoint in the relevant code.

          • January 18, 2009 at 12:26 PM #21522
            community-content

              Thanks Walter, I found this.

              XslTransformException
              ———————
              Cannot find the script or external object that implements prefix ‘http://schemas.microsoft.com/BizTalk/2003/ScriptNS0&#8217;.

               

              <xsl:variable name=”var:v1″ select=”ScriptNS0:RunStoredProcedure(&quot;D:\Runtime\Conn\EAI_Params.xml&quot; , &quot;CF_Timer_Update&quot;)” />

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