Thanks folks,

Turns out to be 10min to load 350k into first

table, select out and load 5 tables and then

do the cursor fixup on the FK table.

It will run each night....

Thanks, folks, for the suggestions. I finally resorted to the cursor method. Takes about 10 minutes to do 300k rows.

I'm sure the problem could be solved in

a better...