Geeks With Blogs

News INETA Community Speakers Program WTFNext's hosting!

View Stacy Vicknair's profile on LinkedIn

WTF Next? Dev ramblings from a master of nothing.

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 forums that helped get this working finally. For us, all that was necessary was to switch the database connection to ODBC over OLE DB. For some reason the OLE DB driver wasn't enjoying the network traffic from the stored procedure the package was calling, or that would be my best guess.

Anyways, score one for having one less thing to waste time on.


Posted on Monday, December 29, 2008 12:40 PM Other | Back to top

Comments on this post: SQL Server 2000 Tip - Protocol error in TDS stream

# re: SQL Server 2000 Tip - Protocol error in TDS stream
Requesting Gravatar...
It really Networka Problem,or you tables needs to re index
Left by ENG. ABDIKARIIM on Dec 16, 2009 1:53 AM

Your comment:
 (will show your gravatar)

Copyright © Stacy Vicknair | Powered by: