SQL Adaptor question

Home Page › Forums › BizTalk 2004 – BizTalk 2010 › SQL Adaptor question

Viewing 1 reply thread
  • Author
    Posts
    • November 23, 2005 at 8:29 PM #12416
      community-content

        I receive following error when trying to use @table variable/#temp table in stored proc which I call using SQL Adaptor wizard. The SQL wizard is able to generate schema fine, and project builds ok. The error happens only when I try to configure receive location for SQLTransport properties. Error msg is – \”This is not a valid schema generated by SQL schema wizard. Type ‘http://myNamespace:_x005F_x0023_TempTableName’ is not declared…..\” Is it not possible to use temp table in stored procs with SQL Adapotor?? any thoughts.
        Thanks in advance.

      • November 28, 2005 at 3:34 PM #12417
        community-content

          Thanks for replying, Steve. The stored proc is ok, I have checked that. If I remove @table variable or #temp_table and replace it with an actual work table, it works fine and I don’t receive the previous error. It makes me think that we can’t use @table variable or #temp_table in stored procs when using SQL Adaptor… is that so?

          • November 24, 2005 at 5:47 AM #12418
            community-content

              You might want to check the current help guide under “SQL Receive Adapter”.

              You must be doing something wrong in the stored proc.

              • November 30, 2005 at 12:58 PM #12419
                community-content

                  I’m not sure on that one, but it could be the case with the SQL Adaptor.

                  • June 26, 2008 at 9:28 AM #20000
                    community-content

                       HI,

                       

                          I am having the same issue as posted origanally. I have a simple query in SP “Select Cols from Table XML AUTO,XMLDATA”. I create schema and deploy the project succesfully. But problem occurs when i try to create a receive location for SAL adapter. It thorws message of “Invalid schema” for every schema generated within the project. I am wondering what could be the problem?

                      Thank you in advance.

                    • June 26, 2008 at 9:28 AM #20001
                      community-content

                         HI,

                         

                            I am having the same issue as posted origanally. I have a simple query in SP “Select Cols from Table XML AUTO,XMLDATA”. I create schema and deploy the project succesfully. But problem occurs when i try to create a receive location for SAL adapter. It thorws message of “Invalid schema” for every schema generated within the project. I am wondering what could be the problem?

                        Thank you in advance.

                        Raminder

                        • June 26, 2008 at 12:53 PM #20004
                          community-content

                             Did you remove the XMLDATA instruction from the stored proc after you generated the schemas

                            • June 27, 2008 at 1:54 AM #20009
                              community-content

                                 Yes, I have removed it from the store procedure sql statement.

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