Personally I would go with SSIS as it was created for this kind of work.

There are many advantages of using SSIS to name but a few:

- Good error handling possibilities

- Bulk Inserts

- Visibility of what is happening in the pipeline

- Configurations

I'm sure there are more that will be added to the thread!

A disadvantage of using SSIS is the appalling error messages and it can at times be a pig to work with (my personal opinion not a statement of fact!)

Question why steps 1 & 2 what are your reasons for dropping and recreating the tables already in place?

Andy