Re: How to update source table once scessfull insertion in destination

On Wed, 15 Aug 2007 11:48:03 -0700, Gurvinder
<Gurvinder@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote:

Once data is inserted in destination i want to update/flag column in source
table for rows that are inserted in that instance or run.. How can I do that.
Could you provide more detailes about your setup? Do you just have a
receive port and a send port? Or do you have an orchestration? If you
need to do something AFTER the update, use an orchestration, and
program logic in there. Baiscally, you need to use an updategram or
stored procedure to set the flag on the source table. You should
encapsulate things in scopes, so you can compensate things that
haven't gone well.

--
eliasen, representing himself and not the company he works for.

Private blog: http://blog.eliasen.dk

Private email: jan@xxxxxxxxxx
.

Relevant Pages

  • Re: Dozens of Schema Serviced By One Receive Location?
    ... orchestration will recieve a message, using a value in the MQMD (MQSeries ... If you simply need to route to a specific send port based on a value ... Private blog: http://blog.eliasen.dk ...
    (microsoft.public.biztalk.general)
  • Re: Send object is not sending transformed XML doc
    ... We decided to create a new orchestration that received Schema A from an "In" ... then sends it as Schema B to the same folder as the Input port of the ... Private blog: http://blog.eliasen.dk ...
    (microsoft.public.biztalk.general)
  • Re: MSMQT read messages in MsgBox
    ... Setup a send port or orchestration that has a subscription to the messages ...
    (microsoft.public.biztalk.general)
  • Re: Flat file, schema, xml
    ... Inside your orchestration you shouldn't change anything. ... physical ports, however, change the transmit type to be HTTP. ... send port no further changes are needed. ... Private blog: http://blog.eliasen.dk ...
    (microsoft.public.biztalk.general)
  • Re: SQL Adapter polling
    ... and return a message to the orchestration. ... Does the SQL adapter send port ... that there is no CPU usage until a message activates ... Private blog: http://blog.eliasen.dk ...
    (microsoft.public.biztalk.general)
Loading