Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
biswasj
Starting Member
1 Post |
 Posted - 2013-08-13 : 11:26:51
|
| MessageExecuted as user: xxxx. Microsoft (R) SQL Server Execute Package Utility Version 10.50.2500.0 for 64-bit Copyright (C) Microsoft Corporation 2010. All rights reserved. Started: 1:30:00 PM Error: 2013-08-12 13:59:38.34 Code: 0x00000000 Source: F_SECTORS Description: OLE DB provider "SQLNCLI10" for linked server "zzzz" returned message "Protocol error in TDS stream". End Error Error: 2013-08-12 13:59:38.36 Code: 0x00000000 Source: F_SECTORS Description: OLE DB provider "SQLNCLI10" for linked server "yyyy" returned message "Communication link failure". End Error Error: 2013-08-12 13:59:38.36 Code: 0x00000000 Source: F_SECTORS Description: Session Provider: Connection has been closed by peer [xFFFFFFFF]. End Error Error: 2013-08-12 13:59:38.36 Code: 0x00000000 Source: F_SECTORS Description: OLE DB provider "SQLNCLI10" for linked server "yyyy" returned message "Communication link failure". End Error Error: 2013-08-12 13:59:38.36 Code: 0x00000000 Source: F_SECTORS Description: Session Provider: Connection has been closed by peer [xFFFFFFFF]. End Error Error: 2013-08-12 13:59:38.36 Code: 0x00000000 Source: F_SECTORS Description: OLE DB provider "SQLNCLI10" for linked server "yyyy" returned message "Communication link failure". End Error Error: 2013-08-12 13:59:38.78 Code: 0xC002F210 Source: F_SECTORS Execute SQL Task Description: Executing the query "truncate table ClientDB.F_SECTORS insert into Clie..." failed with the following error: "Session Provider: Connection has been closed by peer [xFFFFFFFF]. ". Possible failure reasons: Problems with the query, "ResultSet" property not set correctly, parameters not set correctly, or connection not established correctly. End Error DTExec: The package execution returned DTSER_FAILURE (1). Started: 1:30:00 PM Finished: 2:54:04 PM Elapsed: 5043.51 seconds. The package execution failed. The step failed. |
|
|
Bustaz Kool
Master Smack Fu Yak Hacker
1834 Posts |
Posted - 2013-08-19 : 19:20:26
|
| Does this happen every time or intermittantly? Could you be experiencing a network connectivity problem?=================================================The cure for anything is salt water -- sweat, tears, or the sea. -Isak Dinesen |
 |
|
|
|
|
|
Protocol error in TDS stream