|
Home > Archive > BizTalk Server General > December 2005 > use of dynamic parameter stored procedure calls in SQL adapter
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 |
use of dynamic parameter stored procedure calls in SQL adapter
|
|
|
| Is there a way to assign dynamic parameter value in SQL stored procedure
calls when using SQL receive adapter?
Also, does Add Adapter Wizard support the use of the dynamic parameter?
In the MS-Help page
ms-help://MS.VSCC.2003/MS.MSDNQTR.2005OCT.1033/operations/htm/ebiz_ops_adapt_sql_esig.htm, it stated that
The SQL receive adapter supports SQL stored procedure calls that contain
static parameter values. An example of a supported stored procedure call is
as follows:
exec [CustOrdersOrders] @CustomerID="ALFKI"
Any help in this respect is appreciated.
Thanks in advance
Surf
| |
| Selvan 2005-12-23, 7:49 am |
| Surf,
I hope Matt's answer given in the feedback will help you. here is the link
http://objectsharp.com/blogs/matt/a...03/22/1560.aspx
Cheers
Selvan
"surf" wrote:
> Is there a way to assign dynamic parameter value in SQL stored procedure
> calls when using SQL receive adapter?
>
> Also, does Add Adapter Wizard support the use of the dynamic parameter?
>
> In the MS-Help page
> ms-help://MS.VSCC.2003/MS.MSDNQTR.2005OCT.1033/operations/htm/ebiz_ops_adapt_sql_esig.htm, it stated that
>
> The SQL receive adapter supports SQL stored procedure calls that contain
> static parameter values. An example of a supported stored procedure call is
> as follows:
> exec [CustOrdersOrders] @CustomerID="ALFKI"
>
>
> Any help in this respect is appreciated.
>
> Thanks in advance
> Surf
|
|
|
|
|