|
Home > Archive > BizTalk Server General > February 2005 > Dynamic SQL Adapter Send 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 Adapter Send Port
|
|
|
| All,
I'm trying to set up a SQL Adapter Send port to execute a Store Procedure on
a SQL server database. I have my schema defined and my send port. All works
correctly if I specify the address info within the sql adapter send port
properties window. Where I cannot get things working correctly is trying to
dynamically set the sql adapter port from within an orchestration. I'm
wanting to have one orchestration that processes messages and dynamically
sets the sql adapter send port, which in turns executes a single store
procedure on the set database address. Is this possible? Any help would be
appreciated.
| |
| Niklas E 2005-02-10, 5:52 pm |
| Unfortunately, I don't think it is possible.
You could have a look at this though, which is how you can make a Web
Service (Web Service Adapter) work without an orchestration. Perhaps
something similar works for SQL adapter settings as well?
---------
You'll need to write a custom pipeline component that sets
the operation name of the Web service to call. This is
the code you can use in the pipeline component (this can
be used with the CustomComponent pipeline SDK sample that
ships with BTS2004) :
public IBaseMessage Execute(IPipelineContext pc,
IBaseMessage inmsg)
{
try
{
inmsg.Context.Write
("Operation", "http://schemas.microsoft.com/BizTalk/2003/sy
stem-properties", methodName);
}
catch (Exception ex)
{
throw new Exception("WriteMethodName Exception - " +
ex.Message);
}
return inmsg;
}
---------
Best regards
Niklas Engfelt
"Scot" <Scot@discussions.microsoft.com> wrote in message
news:195FFA6A-E8EA-4C2F-BFC3-FDEC3131BA91@microsoft.com...
> All,
>
> I'm trying to set up a SQL Adapter Send port to execute a Store Procedure
> on
> a SQL server database. I have my schema defined and my send port. All
> works
> correctly if I specify the address info within the sql adapter send port
> properties window. Where I cannot get things working correctly is trying
> to
> dynamically set the sql adapter port from within an orchestration. I'm
> wanting to have one orchestration that processes messages and dynamically
> sets the sql adapter send port, which in turns executes a single store
> procedure on the set database address. Is this possible? Any help would
> be
> appreciated.
>
|
|
|
|
|