I had to get a copy of one of my clients sql server db tables onto my local sql server. For some reason DTS was failing on a particular record and I couldn't identify the problem or the record or the error.

I finally gave up and went over to my whidbey box, set up an ADO.NET bulk copy and streamed the data from the remote sql server into the table on my local server.

(Without having to learn how to do a bulk copy in SQL Server)

What a great feeling!