@nathan because database operations terminate the return of rows. @alex I would use any one of the inputcommandoperations. I try to use the conventionbulksqlcommandoperation as much as possible. but anyone will do.
On Jan 12, 5:20 pm, Alex Brown <[email protected]> wrote: > but what should the "update from original..." operation be? > An AbstractDatabaseOperation? InputCommandOperation? > > On Jan 12, 9:40 pm, Nathan Palmer <[email protected]> wrote: > > > Why would you choose a branching operations instead of just 3 operations one > > after another? > > > register("select from original.."); > > register("insert into destination.."); > > register("update from original..."); > > > On Wed, Jan 12, 2011 at 1:14 PM, Jason Meckley > > <[email protected]>wrote: > > > > get data and branch to insert and update > > > > register("select ..."); > > > register(new BranchingOperation() > > > .Add("insert into...") > > > .Add("update ...")); > > > > On Jan 12, 12:29 pm, Alex Brown <[email protected]> wrote: > > > > Hi, > > > > I'm currently writing a few etl processes to move rows from one table > > > > to another. > > > > > Firstly, I have an ImportCommandOperation that is basically doing > > > > "SELECT * FROM table WHERE Transferred = 0" > > > > This is working fine. > > > > > Then, I have a write operation to insert the rows > > > > > Finally, I need an operation that Updates the source table, sets > > > > Transferred to 1 > > > > > How should I go about doing this? > > > > -- > > > You received this message because you are subscribed to the Google Groups > > > "Rhino Tools Dev" group. > > > To post to this group, send email to [email protected]. > > > To unsubscribe from this group, send email to > > > [email protected]<rhino-tools-dev%2Bunsubscribe@ > > > googlegroups.com> > > > . > > > For more options, visit this group at > > >http://groups.google.com/group/rhino-tools-dev?hl=en. -- You received this message because you are subscribed to the Google Groups "Rhino Tools Dev" group. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/rhino-tools-dev?hl=en.
