Hello guys, I get one issue when I tried to run a job. It gives me below error. Please help me out from this. Executed as user: CONTECH\sqlserver. TCP Provider: The semaphore timeout period has expired. [SQLSTATE 07008] (Error 121) Session Provider: Physical connection is not usable [xFFFFFFFF]. [SQLSTATE 42000] (Error 65535) Session Provider: Physical connection is not usable [xFFFFFFFF]. [SQLSTATE 42000] (Error 65535) OLE DB provider "SQLNCLI" for linked server "SQL2" returned message "Protocol error in TDS stream". [SQLSTATE 01000] (Error 7412) OLE DB provider "SQLNCLI" for linked server "SQL2" returned message "Communication link failure". [SQLSTATE 01000] (Error 7412) OLE DB provider "SQLNCLI" for linked server "SQL2" returned message "Communication link failure". [SQLSTATE 01000] (Error 7412) OLE DB provider "SQLNCLI" for linked server "SQL2" returned message "Communication link failure". [SQLSTATE 01000] (Error 7412). The step failed. Thank s in advance. Maulik

Please refer to the below link for the solution http://blogs.msdn.com/b/jneave/archive/2011/04/15/tcp-provider-error-semaphore-timeout-from-an-ssis-package.aspx

I am having this same issue however my priority boost was already set to 0