Re: SQL Adapter send port - select statements?

From: Xerox (Xerox_at_discussions.microsoft.com)
Date: 11/22/04


Date: Mon, 22 Nov 2021 07:09:09 -0800

Cool. That sounds what I am looking for. I'll give it a go. Thanks for all
your responses guys.

"Lars W. Andersen" wrote:

> You could also try using a request-respond port and set the SQL port up as a
> send port. I am using that as a lookup in an orchestration, with a select
> statement. Works fine.
> regards
> Lars
>
> "Xerox" <Xerox@discussions.microsoft.com> wrote in message
> news:F2A004AF-8149-4E69-9CE5-8E1D29859978@microsoft.com...
> > Thinking on it, this is the part that confuses me: When setting up a SQL
> > receive port using the BizTalk explorer you must specify a polling
> frequency
> > attribute. But I do not want to poll I simply want to read data from the
> SQL
> > port on demand from my orchestration.
> >
> > Can you explain where my thinking is wrong?
> >
> > "Matt Milner" wrote:
> >
> > > 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