If you really need a flat file and DTS is not suitable then the bcp utilily might be worth a look. It is quite powerful. You can use it for import...

You may find sp_help_revlogin useful. I have used it when migrating a database, to help transfer the relevant logins *and* passwords to the new server. But it can just as easily be used...

What you outlined is a really useful technique, I have used it many times.

However sometimes you may need something a little more complicated. In those situations the OPENROWSET statement may...