I don't think you can overlook the usefulness of bcp and/or bulk insert. They're frequently overlooked in favor of SSIS. Many times SSIS is overkill for loading/producing simple files.

I have a love/hate thing going with intellisence.

On the wish list is the ability to bundle procedures and functions into a class (similar to oracle packages).