Error using BTS Adapter for SQL Server — invalid object?

Home Page › Forums › BizTalk 2004 – BizTalk 2010 › Error using BTS Adapter for SQL Server — invalid object?

Viewing 0 reply threads
  • Author
    Posts
    • #17754

      I'm trying to call a stored procedure on the local server that also stores my Biztalk installation.  The SP is in a logging database I have and I'm logging my incoming messages to include the source application name, the message type and the actual XML string of the message.

      I can call the SP just fine from Query Analyzer, but after I create the schemas from the adapter and try to call the adapter via a send port in an orchestration, I receive an error from the port stating that it could not locate a table that used to exist in the database.  Now, the SP that is being called has NO link to the table or object that is being reported on as an error.

      Anybody seen this before?

      TIA
      -Rich

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