|
Home > Archive > BizTalk Server Applications Integration > July 2004 > .NET component in 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 |
.NET component in send port
|
|
| ramani viswanathan 2004-07-03, 6:51 pm |
| Is it possible to configure a .NET component in send port in Biztalk 2004? If not, hat is the best way to achieve this?
Thanks
Ramani
| |
| Nick Malik 2004-07-04, 3:15 am |
| What are you trying to accomplish? There may be more than one way to
achieve your goal.
--- Nick
"ramani viswanathan" <ramaniviswanathan@discussions.microsoft.com> wrote in
message news:9D3417D6-EC0C-4C3A-BCF5-3944C5C38DAF@microsoft.com...
> Is it possible to configure a .NET component in send port in Biztalk 2004?
If not, hat is the best way to achieve this?
>
> Thanks
> Ramani
| |
| ramani viswanathan 2004-07-04, 5:50 pm |
| I configured a SQL receive adapter at my receive port, which runs a sql query to fetch certin records matching a condition. These records will be output to a send port as xml documents configured with file adapter. Just after this point, I want to update
the output records with a condition, that they won't be output next time the query runs. I want to perform this updation from .NET component. I did this in Biztalk 2002. What is the best way achieve this in Biztalk 2004?
Thanks
Ramani
"Nick Malik" wrote:
> What are you trying to accomplish? There may be more than one way to
> achieve your goal.
>
> --- Nick
> "ramani viswanathan" <ramaniviswanathan@discussions.microsoft.com> wrote in
> message news:9D3417D6-EC0C-4C3A-BCF5-3944C5C38DAF@microsoft.com...
> If not, hat is the best way to achieve this?
>
>
>
| |
| Nick Malik 2004-07-04, 8:46 pm |
| Sure.. Three reasonable ways:
Method 1) trust the components: configure the SQL adapter to call a stored
procedure that will produce your data and, at the same time, mark it as
sent. This is very efficient, since you never have to return to SQL. It's
also fairly scary for those of us who panic when we mark something as "done"
when it isn't really!
Method 2) receipts: configure your input port as a recieve-send port and
create an orchestration that produces a receipt message with the key values
of the records. Configure the receipt port to update your SQL Server system
when it gets a receipt.
Method 3) orchestration: add an orchestration between the receive port and
the send port. In the orchestration, add a shape to call your .NET
component with the unique key value promoted from the schema. Your
component will be called once for each record you pass through.
These are better options than the method of updating the send pipeline. If
you want to update the send pipeline, create a custom pipeline, and add a
component after the serializer.
--- Nick
"ramani viswanathan" <ramaniviswanathan@discussions.microsoft.com> wrote in
message news:F8768D10-8768-4011-BD4C-36FFA7369EFA@microsoft.com...
> I configured a SQL receive adapter at my receive port, which runs a sql
query to fetch certin records matching a condition. These records will be
output to a send port as xml documents configured with file adapter. Just
after this point, I want to update the output records with a condition,
that they won't be output next time the query runs. I want to perform this
updation from .NET component. I did this in Biztalk 2002. What is the best
way achieve this in Biztalk 2004?[vbcol=seagreen]
>
> Thanks
> Ramani
>
> "Nick Malik" wrote:
>
in[vbcol=seagreen]
2004?[vbcol=seagreen]
|
|
|
|
|