BizTalk Server General - SQL adapter question

Author

SQL adapter question

julieannek@gmail.com

2005-09-26, 7:49 am

I need to create an SQL adapter which will allow the execution of two
select statements/stored procedures.

First of all is this possible? I had originally tried creating two SQL
adapters which each had a single select statement. However this
approach doesn't work when you attempt to configure the receive
locations, as it complains the uri of the second receive location is
not correct as it already being used.

Any help would be much appreciated. The reason I want to use the
adapter is so I can configure the select statements to be executed at
particular intervals.

ramani viswanathan

2005-09-26, 5:59 pm

you can edit the URI in the receive location to make it unique. This way you
can have multiple receive locations for the same database connection.

"julieannek@gmail.com" wrote:

> I need to create an SQL adapter which will allow the execution of two
> select statements/stored procedures.
>
> First of all is this possible? I had originally tried creating two SQL
> adapters which each had a single select statement. However this
> approach doesn't work when you attempt to configure the receive
> locations, as it complains the uri of the second receive location is
> not correct as it already being used.
>
> Any help would be much appreciated. The reason I want to use the
> adapter is so I can configure the select statements to be executed at
> particular intervals.
>
>