I have a DTS set up that copies data across from the live server to a local "backup/development" copy. Everything runs fine except on occation the DTS fails kicking up a "Protocol error in TDS stream" The table that fails has just about 11,000 rows. It tends to get to about 70% complete before it fails. Is this just a network traffic issue (I'm on a domestic 1 meg connection) or has my table got too big?
It may be more of an issue with the version of Excel you're using as well. I received this error using MS Excel 2007. I looked at the connection properties and un-checked the option of "Enable Background Refresh" and it resolved the issue.
The Hotfix from MS, had some ugly instructions of backing up the machines system before installing the Hotfix. I decided to try and reduce the query time and found the Refresh Options.