Re: BizTalk 2004 SQL Adapter

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: Michael (Michael_at_xyzzy.com)
Date: 04/19/04 

Date: Mon, 19 Apr 2004 11:26:52 -0400

An incoming document is mapped to database stored procedures in the
mapper to store the document in the database. Because it has a header
detail relationship, the header is mapped to a stored procedure to
write the header and the detail is mapped to stored procedure to store
detail. The detail is also connected with a looping functoid to call
the detail stored procedure once per detail item.

Yes, I need the send port to execute multiple stored procedures. What
I don't understand is that the migration wizard copies the same old
stored procedure schema, where each stored procedure is a Record node
with a name attribute and each parameter is a Record node with a
name/value pair.

But this doesn't look anything like the schema generated for a send
port that calls a stored procedure in BizTalk 2004. That schema has
the name of the parameters as the attribute node name.

On Fri, 16 Apr 2004 21:36:28 GMT, evyang@online.microsoft.com (Everett
Yang) wrote:

>I am a bit unclear as to the overall design. Please let me know if I am
>missing something.
>If you plan to make database calls from Mapper, you don't need to generate
>any schema for SQL Adapter. If you generate a schema from the SQL Adapter,
>it'll be for inbound document or the send port. Do you need the send port
>to execute multiple stored procedures?
>
>
>Sincerely,
>
>
>Everett Yang
>DSI - Microsoft BizTalk Server
>
>This posting is provided “AS IS” with no warranties, and confers no rights.
>Subscribe at
>http://support.microsoft.com/default.aspx?scid=/servicedesks/msdn/nospam.asp
>&SD=msdn

Relevant Pages

  • Re: sql2k5 security
    ... you could give a user only Execute permissions on a ... stored procedure and the stored procedure could perform operations fine. ... Create a table in the database. ... Create a Schema named mySchema in the database. ...
    (microsoft.public.sqlserver.security)
  • Re: Extended Stored Procedure: Get the current db of the client
    ... with the caveat that you don't recommend it because Microsoft ... of a stored procedure versus umpteen of the same stored procedure spread ... I am not going after Gert Sue. ... the database context as a parameter if you need it, ...
    (microsoft.public.sqlserver.odbc)
  • Trying to set up a SQL Server Agent Account and I hit a wall....
    ... Our database is on SQL Server 2005, however it is set to compatibility mode ... You may need to set the compatibility level ... of the current database to a higher value to enable this feature. ... for the stored procedure sp_dbcmptlevel. ...
    (microsoft.public.sqlserver.security)
  • Re: Extended Stored Procedure: Get the current db of the client
    ... I am not going after Gert Sue. ... the database context as a parameter if you need it, ... Did you ever write an extended stored procedure? ... different than an extended stored procedure, so that is not giving you want ...
    (microsoft.public.sqlserver.odbc)
  • Re: Extended Stored Procedure: Get the current db of the client
    ... Thanks for the link Sue. ... I am not going after Gert Sue. ... the database context as a parameter if you need it, ... Did you ever write an extended stored procedure? ...
    (microsoft.public.sqlserver.odbc)