none
The semaphore timeout period has expired

    Question

  • i have faced following error in SSIS:

    in SSIS: I have For Loop: Which proceses 1lac records in each Loop
    After Processing 3billion records it shown following error:
    How can i troubleshoot:

    A transport-level error has occurred when receiving results from the server. (provider: TCP Provider, error: 0 - The semaphore timeout period has expired.)".

    manish
    Monday, October 26, 2009 6:11 AM

Answers

  • Hi,

    That's a general error and there are lots of reasons which may be the cause of that issue.

    What is the version of your SQLServer?

    If you are using SQLServer SP1 and there's user defined function involved in your package, you may try the following KB article:

    http://support.microsoft.com/kb/924291/

    Is your SQLServer running on Windows Server 2003? If so, you may also receive that error message when the network load on SQL Server is high. And the problem occurs because the TCP Chimney Offload feature is enabled on the server. Try to following link on how to get the workaround.

    http://support.microsoft.com/kb/942861/

    Thanks.


    Microsoft Online Community Support Please remember to mark the replies as answers if they help and unmark them if they provide no help.
    • Marked as answer by LearnerSql Wednesday, February 17, 2010 3:19 PM
    Thursday, October 29, 2009 3:22 AM
    Moderator

All replies