BizTalk Server Applications Integration - How to insert using SP instead of an updategram (SQL adapter)

Author

How to insert using SP instead of an updategram (SQL adapter)

2006-01-13, 9:54 pm

Hi

I'm using the SQL adapter to insert into SQL server. I'm need to use a
stored procedure to perform the insert since there are a few conditional
statements I need to execute as part of the business logic. So far I've only
found sample on inserting using updategrams.

How can I insert data using a stored procedure onthe SQL send adapter?

Thanks in advance
AL

Jan Eliasen

2006-02-14, 7:48 am

On Thu, 12 Jan 2006 05:25:02 -0800, "AL"
<AL@discussions.microsoft.com> wrote:

>I'm using the SQL adapter to insert into SQL server. I'm need to use a
>stored procedure to perform the insert since there are a few conditional
>statements I need to execute as part of the business logic. So far I've only
>found sample on inserting using updategrams.
>
>How can I insert data using a stored procedure onthe SQL send adapter?
Hi

Try downloading the updated BizTalk 2004 documentation, and open it.
Go to "Operations" => "Connecting applications using native adapters"
=> "SQL Adapter". In here, should be the information you are seeking.

--
Eliasen Jr. representing himself and not the company he works for.

Private email: jan@eliasen.dk