This tip might not fix everyone's issue, but for the problem I was facing today this worked out just fine. We have a scheduled weekly DTS package that is failing for the reason specified in this title: "Protocol error in TDS stream". For weeks we've just been running the thing manually, but that's not a solution, just a delay of the problem. I decided to investigate. I found an article on the SQLTeam.com forums that helped get this working finally. For us, all that was necessary was to switch the...