January 13, 2014 at 11:49 pm
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.
January 13, 2014 at 11:59 pm
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
January 15, 2014 at 12:01 am
Yes Sir
Also using bulk insertion on a table
January 15, 2014 at 4:32 am
Dharmendra JKT (1/15/2014)
Yes SirAlso 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
January 16, 2014 at 1:42 am
No
August 8, 2014 at 1:37 am
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.
November 29, 2014 at 10:55 am
I would suggest you to have a look at these links :
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 )
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.
December 28, 2015 at 9:38 am
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
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy