Re: SQL Adapter send port - select statements?

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

From: Matt Milner (matt.milner_at_m3technologypartners)
Date: 11/18/04 

Date: Wed, 17 Nov 2004 21:53:57 -0600

You can, but you are RECEIVING data, not sending. You have to setup your
send port accordingly. This is done by using the Add Generated Items menu
item from the context menu on a biztalk project. Make sure you say you are
receiving and then you can define either a stored procedure, or a select
statement.

Matt

"Xerox" <Xerox@discussions.microsoft.com> wrote in message
news:8366E734-9CC1-4BA6-B300-58766B4C7E48@microsoft.com...
>I want to read data from SQL Server part way through my orchestration. As
>far
> as I know, the only option to do this is to call a stored procedure to
> return
> data to the orchestration. Why can I not issue a select statement instead?
>
> "Mike Watson" wrote:
>
>> Maybe I am missing something here.. But why would you need to do a SELECT
>> to
>> a send port?? All a SELECT does is return data to you (BizTalk 2004),
>> this is
>> always done on a receive port.
>> - Mike
>>
>> "Xerox" wrote:
>>
>> > Why are select statements not supported for the SQL Adapter send port?
>> > Updategrams are supported and stored procedure calls are supported, but
>> > not
>> > select statememts.
>> >
>> > It seems a shame as this breaks the self-contained nature of an
>> > orchestration in that it now expects to have a stored procedure present
>> > in
>> > the database for it to retrieve data.
>> >
>> > Are there plans to implement select on a send port?

Relevant Pages

  • Re: Help in sending Biztalk messages to SQL Server 2005
    ... then a stored procedure would be the way to go. ... Use the SQL Adapter to generate an insert schema for you, ... This will actually add an orchestration and a schema to your solution, ... After that when you deploy it will create the SQL port for you and ...
    (microsoft.public.biztalk.general)
  • Re: SQL adapter responsibility
    ... > Yes, you would call a stored procedure to do your insert, update or ... > orchestration like any other message. ... I am using BizTalk 2004 version. ... > success) from SQL adapter to send to another port? ...
    (microsoft.public.biztalk.general)
  • RE: SQL Adapter send port - select statements?
    ... I want to read data from SQL Server part way through my orchestration. ... >> Why are select statements not supported for the SQL Adapter send port? ... >> Updategrams are supported and stored procedure calls are supported, ...
    (microsoft.public.biztalk.general)
  • How to use sql adapter without an orchestration
    ... Is ist possible to use the sql-adapter to call a stored procedure without ... using an orchestration? ... If I try to use a static one way port, it doesn't produce any errors but it ... procedure is called becauce if I put in a commit in the stored procedure it ...
    (microsoft.public.biztalk.general)
  • Re: System.OutOfMemoryException was thrown
    ... Receive Location configured with the Sql Adapter picks up messages that ... Send Port subscribes to the above messages and then Send Ports Send ... Logical Port in orchestration is then bound to physical MQ port end point. ... Exception type: PersistenceItemException ...
    (microsoft.public.biztalk.general)