Connectivity Problems

  • Hi,

    I am Dharmendra Kumar, I am facing this problems, can any one help me to resolve this problems.

    ABC\dmsadmin. Microsoft (R) SQL Server Execute Package Utility Version 10.50.2500.0 for 32-bit Copyright (C) Microsoft Corporation 2010. All rights reserved. Started: 1:10:47 AM Error: 2014-01-07 01:49:31.05 Code: 0x00000000 Source: blankcashnet to Dummy_CASHNET Description: TCP Provider: The semaphore timeout period has expired. End Error Error: 2014-01-07 01:49:31.05 Code: 0xC002F210 Source: blankcashnet to Dummy_CASHNET Execute SQL Task Description: Executing the query "insert into SSIS_check (task_name) values ('ITM da..." failed with the following error: "Communication link failure". 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:10:47 AM Finished: 1:49:31 AM Elapsed: 2323.46 seconds. Process Exit Code 1. The step failed.

  • At first sight it seems you're experiencing network issues.

    Are you running the package on the same server where the database is?

    Need an answer? No, you need a question
    My blog at https://sqlkover.com.
    MCSE Business Intelligence - Microsoft Data Platform MVP

  • Yes Sir

    Also using bulk insertion on a table

  • Dharmendra JKT (1/15/2014)


    Yes Sir

    Also using bulk insertion on a table

    Maybe there is excessive locking? Any other processes accessing the tables?

    Need an answer? No, you need a question
    My blog at https://sqlkover.com.
    MCSE Business Intelligence - Microsoft Data Platform MVP

  • No

  • your problem is too complicated for me also i am trying to resolve it through my programmers and developers hope they find solution soon. I will get you back in few days you just wait for my reply.

  • I would suggest you to have a look at these links :

    http://blogs.msdn.com/b/jneave/archive/2011/04/15/tcp-provider-error-semaphore-timeout-from-an-ssis-package.aspx

    http://blogs.msdn.com/b/oldnewthing/archive/2014/07/17/10543082.aspx

    (Remark :according this last link , it seems that this problem was usual on Windows Server 2003 , Server 2005 and their old TCP/IP )

    http://blogs.msdn.com/b/prethishkumar/archive/2012/02/04/high-performing-biztalk-server-2009-biztalk-server-2010-server-setup.aspx

    Maybe , I have read your question too quickly but I don't think to have seen any information about the full version ( year + last installed SP ) of your SQL Server and about the version/edition of the OS of the machine where the SQL Server is installed. If you could provided this information , it would be useful to find the cause of your problem.

    Have a nice day.

  • Hello Every Body I am Asif Ali from Learn2Free and student of software engineering. I have completed in first semester my last subject is SQL Server I have facing different problem on my assignments, I have visit sqlservercentral web and I have learn it easily after that my all assignment is completed. So I recommended with don't jumped an other website.

Viewing 8 posts - 1 through 7 (of 7 total)

You must be logged in to reply to this topic. Login to reply