mmm, I caught the problem. In the JoinOperation, I had 2 key columns, one was of type long, the other was of type ulong (unsigned long) ... which caused the join to match nothing !!
I had to use NestedLoopsJoinOperation to manually do the join and track the problem. Is something wrong with Rhino etl ?? On May 15, 3:59 pm, Simone Busoli <[email protected]> wrote: > What's wrong? Sounds correct to me. > > > > On Sat, May 15, 2010 at 11:49, jalchr <[email protected]> wrote: > > Hello > > Inserting to a database is simple and straight forward. I'm trying to > > synchronize a table, so existing records should get updated. > > I'm trying to do this as follows > > 1) I read source table with a read operation > > 2) I read destination table with a read operation > > 3) I perform a join on both read operations (??) in order to determine > > existing (??) vs. new records (??) > > 4) for new records, mark them for "Insert" > > 5) mark existing records for "Update" > > > I can see something is wrong over here, but can point the solution, > > any ideas? > > > -- > > 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%[email protected]> > > . > > 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 > athttp://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.
