Thanks Lynn, I guess I'm learning that these performance "rules" really are not hard and fast.  I don't expect them to be but it sure is causing me frustration trying...

Thank you for your reply but I'm still not sure I understand.  Since I am joining the two tables, it should have to loop through all 24.6M iterations - at...

Thank you George. 

I was able to use the import wizard to import the data and now join it with production data - and I don't have write permission to...

Wow, I'm very interested in doing this - I am often requested to join production data, which I don't have write access to, with "outside data".  If I could get...

I am curious how your test went.  I would think that the batch size wouldn't change the performance that much of the loading - but that it impacts how the DTS...