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

[ Post a follow-up to this message ]

On Wed, 15 Aug 2007 11:48:03 -0700, Gurvinder
<Gurvinder@discussions.microsoft.com> wrote:
[vbcol=seagreen]
>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.[/vbco
l]
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

[ Post a follow-up to this message ]