This article should be very comprehensive and helpful.
http://msdn.microsoft.com/library/d...-us/BTS_2004WP/
html/74cfc9d0-0974-4f4a-81f5-6768ff245df1.asp

You'll be using the SQL Adapter Wizard in VS to create an access schema for
the stored proc.  Open VS... Right click on the project and Add Generated
Items...  Adapter ... SQL and configure the stored proc with parameters.
It will generate a schema for you to use for the result set.  From
transport properties of the SQL receive location, you can use the schema to
specify the connection string information so the RL can access the stored
proc.  That's it in a nutshell, but the docs should help considerably.

HTH,
Doug Girard [MSFT]

Note: This posting is provided "AS IS" with no warranties, and confers no
rights.
--------------------
>Thread-Topic: Stored Procedure for Biztalk
>thread-index: AcVxt5tH2EJlIu/dTtyvFW8o7EJmnw==
>X-WBNR-Posting-Host: 195.188.27.49
>From: "examnotes"
<RohanSootarsing@discussions.microsoft.com>
>Subject: Stored Procedure for Biztalk
>Date: Wed, 15 Jun 2005 07:36:24 -0700
>Lines: 11
>Message-ID: <26D16389-95F5-4D6D-88E5-6F8AA0153D32@microsoft.com>
>MIME-Version: 1.0
>Content-Type: text/plain;
>	charset="Utf-8"
>Content-Transfer-Encoding: 7bit
>X-Newsreader: Microsoft CDO for Windows 2000
>Content-Class: urn:content-classes:message
>Importance: normal
>Priority: normal
>X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.0
>Newsgroups: microsoft.public.biztalk.general
>NNTP-Posting-Host: TK2MSFTNGXA03.phx.gbl 10.40.2.250
>Path: TK2MSFTNGXA01.phx.gbl!TK2MSFTNGXA03.phx.gbl
>Xref: TK2MSFTNGXA01.phx.gbl microsoft.public.biztalk.general:14727
>X-Tomcat-NG: microsoft.public.biztalk.general
>
>Hi there I am trying to write a stored procedure to query biztalk based on
a
>variable passed to it from biztalk and return all the values in a table
back
>to biztalk.
>Can anyone give me some tips on this.
>This is what ive tried so far
>
>CREATE PROCEDURE [dbo].[test](@REF varchar(50)) AS
>
>SELECT * FROM ctx4nthg WHERE REF = '@REF' for xml auto
>GO
>
>

[ Post a follow-up to this message ]