Hi I've just started out writing a new Rhino.Etl project for a data migration we're doing here. The migration needs to be speedy as we need to import > 3,000,000 user records from an old legacy db to a new system and we only have a small timeframe on the night with which to do this. Which is why we chose R.Etl :)
My question is - as a basic usage - we're extracting records from table a, b and c. Specific columns from those tables are merged to create a new row which is inserted into table x. I then need to get the ID of that new row and use it to insert another row into another table further down the pipeline. What's the best way of getting that? I don't think doing a select straight after the initial insert is best. Is there a way to use @@IDENTITY inside the OutputCommandOperation? Cheers :) w:// -- 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.
