How to insert using SP instead of an updategram (SQL adapter)
Web Server forum
Back To The Forum Home!Search!Private Messaging System

Web Server Talk Web Server Talk > Web Servers reviews > BizTalk Server > BizTalk Server Applications Integration > How to insert using SP instead of an updategram (SQL adapter)




  Last Thread   Next Thread Next
  Show Printable Version Email this Page Subscribe to this Thread      Post New Thread    Post A Reply      

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


View Ip Address Report This Message To A Moderator Edit/Delete Message


 
01-14-06 02:54 AM

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





[ Post a follow-up to this message ]



    Re: How to insert using SP instead of an updategram (SQL adapter)  
Jan Eliasen


View Ip Address Report This Message To A Moderator Edit/Delete Message


 
02-14-06 12:48 PM

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 onl
y
>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





[ Post a follow-up to this message ]



    Sponsored Links  




 





   All times are GMT. The time now is 04:25 PM.      Post New Thread    Post A Reply      
  Last Thread   Next Thread Next


Most Popular forums 

Forum Jump:
Rate This Thread:

Forum Rules:
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
HTML code is OFF
vB code is ON
Smilies are ON
[IMG] code is OFF
 
Medical and Health forum | Computer Games Reviews | Graphics design forum

Back To The Top
Home | Usercp | Faq | Register