BizTalk Server - Dynamic SQL send/receive port??

This is Interesting: Free IT Magazines  
Home > Archive > BizTalk Server > November 2007 > Dynamic SQL send/receive port??





You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

Author Dynamic SQL send/receive port??
steven.p24@googlemail.com

2007-11-30, 7:27 am

HI,
few doubts abt sql adapter it will be great if you can clarify it.

1. Can sql receive location can have dynamic where condition query? i
mean if i create a sql rloc which uses a sp to get the customer
records based on cutomer id and this cusomer id will be passed
dynamically..is it possible ?

2. is it possible to have dynamic sql send port? i mean u need to
specify sp name for send port at design time only.is it possible to
give this sp name to send port at run time ?? if i compare it to IBM
MQ where u can specify the queue name runtime in orchestration so 1
port can send message to 100 diff queues..
Jan Eliasen

2007-11-30, 7:27 am

On Thu, 29 Nov 2007 13:01:48 -0800 (PST), "steven.p24@googlemail.com"
<steven.p24@googlemail.com> wrote:

> few doubts abt sql adapter it will be great if you can clarify it.

I answered you in the .orchestration newsgroup.

--
eliasen, representing himself and not the company he works for.

Private blog: http://blog.eliasen.dk

Private email: jan@eliasen.dk
steven.p24@googlemail.com

2007-11-30, 7:27 am

On Nov 29, 10:02 pm, Jan Eliasen <elia...@nospam.nospam> wrote:
> On Thu, 29 Nov 2007 13:01:48 -0800 (PST), "steven....@googlemail.com"
>
> <steven....@googlemail.com> wrote:
>
> I answered you in the .orchestration newsgroup.
>
> --
> eliasen, representing himself and not the company he works for.
>
> Private blog:http://blog.eliasen.dk
>
> Private email: j...@eliasen.dk


Thanks Eliasen
Sponsored Links






Free braindumps | Software forum | Database administration forum

Copyright 2003 - 2008 webservertalk.com