Well, I found out two things.
1. If you are passing a dataset to import, it MUST be a table in the same database/connection as the insert to table. Seeing as how the output of the SQL is. 2. If you are inserting into oracle, double-quotes causes the table and column names to be case sensitive, this causes an error "OCIError: ORA-00942: table or view does not exist" if you don't know the correct case. Item 1 can't be resolved as i'm using two separate databases for the source and destination data. Item 2 can work as long as I correctly case the table names. I went from 33 minutes to 25 seconds on my job using this. -- You received this message because you are subscribed to the Google Groups "sequel-talk" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To post to this group, send email to [email protected]. Visit this group at https://groups.google.com/group/sequel-talk. For more options, visit https://groups.google.com/d/optout.
