|
Home > Archive > BizTalk Server > August 2007 > How to update source table once scessfull insertion in destination
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 |
How to update source table once scessfull insertion in destination
|
|
| Gurvinder 2007-08-15, 7:17 pm |
| Hi All,
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.
Thanks,
Gurvinder
| |
| Jan Eliasen 2007-08-15, 7:17 pm |
| On Wed, 15 Aug 2007 11:48:03 -0700, Gurvinder
<Gurvinder@discussions.microsoft.com> 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@eliasen.dk
|
|
|
|
|