Is it possible to configure a .NET component in send port in Biztalk 2004? I
f not, hat is the best way to achieve this?

Thanks
Ramani

[ Post a follow-up to this message ]

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

[ Post a follow-up to this message ]

I configured a SQL receive adapter at my receive port, which runs a sql quer
y 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 th
is  point, I want to update
the output records with a condition, that they won't be output next time  th
e query runs. I want to perform this updation from  .NET component. I did th
is 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 i
n
> message news:9D3417D6-EC0C-4C3A-BCF5-3944C5C38DAF@microsoft.com... 
> If not, hat is the best way to achieve this? 
>
>
>

[ Post a follow-up to this message ]

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] 

[ Post a follow-up to this message ]