473,783 Members | 2,363 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Linked server: TCP Provider: An existing connection was forcibly closed by the remote

Hi All,
I need your help regarding Linked server.
We have two different locations for our two servers and I want to transfer my data from one server to another server every day. For that I used linked server.
Both are SQL Server 2005 and operating system 2008.
If I transfer data say about 10000 records it works fine.
But when I am trying to send more then 10000 rows then I am getting some error after 30 to 40 min.
Below is the error massage.

- Copying to [XXXXXXXXXXXx].[dbo].[XXXXXXXXXXXXXXX Xx] (Error)
Messages
• Error 0xc0202009: Data Flow Task: SSIS Error Code DTS_E_OLEDBERRO R. An OLE DB error has occurred. Error code: 0x80004005.
An OLE DB record is available. Source: "Microsoft SQL Native Client" Hresult: 0x80004005 Description: "Communicat ion link failure".
An OLE DB record is available. Source: "Microsoft SQL Native Client" Hresult: 0x80004005 Description: "TCP Provider: An existing connection was forcibly closed by the remote host.
".
(SQL Server Import and Export Wizard)

• Error 0xc0209029: Data Flow Task: SSIS Error Code DTS_E_INDUCEDTR ANSFORMFAILUREO NERROR. The "input "Destinatio n Input" (107)" failed because error code 0xC020907B occurred, and the error row disposition on "input "Destinatio n Input" (107)" specifies failure on error. An error occurred on the specified object of the specified component. There may be error messages posted before this with more information about the failure.
(SQL Server Import and Export Wizard)

Please help me to find some solution.
Thanks
Prakash Paul
Nov 20 '10 #1
0 1571

Sign in to post your reply or Sign up for a free account.

Similar topics

1
2052
by: js | last post by:
I need to create a relationship between a local table and tables on a linked server. I used the design table wizard and selected the relationship property wizard. In the reslationship property wizard, the tables that I need to get the keys from in the linked server do not show up. Is there a way to do this, or I simply don't have enough permission to tables in the linked server. On the local server, the Security tab of linked server...
0
1374
by: ashima | last post by:
Hi, I am trying to add a webservice.I provide a reference to the wsdl file on the server. It works fine when I compile the code on my machine. But on the server, I get the above error with the same compiled code. UNDERLYING CONNECTION WAS CLOSED.REMOTE NAME COULD NOT BE RESOLVED. I read some of the articles which indicate a problem with the proxy server but our client does not have any proxy server. Their server is behind a firewall...
0
2402
by: Mike | last post by:
VB .NET 2003, Pocket PC 2003, CF 1.0 SP 2 Only when I use a proxy server, I'm getting this error when attempting to write data to a Stream object from an HTTPWebRequest object. (System.IO.Stream.Write() raises the exception):"An existing connection was forcibly closed by the remote host". The error only happens with fairly large amounts of data (around 24,500 bytes). Here is ToString() of the exception object raised:
5
24763
by: Vijayakrishna Pondala | last post by:
Hi, We are using the following error randomly, when accessing a webservice method/servlet hosted on JBoss application server: The underlying connection was closed: An unexpected error occurred on a receive. We are using .NET v1.1.
0
1209
by: Sanjay T | last post by:
Hi, We are using ASP.Net 2005 and SQL Server 2005. We are storing sessions in the database. From time to time we get the following exception in the application while the ASP.Net session tries accessing the database. This also happens from time to time when our application is accessing the database. To make the posting brief, I am just putting part of the exception. Any ideas why this might be happening? Our web application is behind F5...
0
2206
by: donsom | last post by:
Using a SQL Login account to attempt to run based LDAP query against Active Directory on a Domain Controller. Originally used ADSI and pulled from Exchange Server AD. New network (multiple domains and different user groups) demanded ADSDSOObject query which included passing account User/Pass from an account on the Domain Controller (with limited permissions). This functioned. New single domain is now in place. An instance of VMWare based...
2
3904
by: OrcaDK | last post by:
Hi I've started receiving sporadic SqlExceptions throughout my .NET applications (crossing ASP.NET, Windows Services, Winforms - doesn't seem application code specific): System.Data.SqlClient.SqlException: A transport-level error has occurred when sending the request to the server. (provider: TCP Provider, error: 0 - An existing connection was forcibly closed by the remote host. The SQL Server (Dell PE1950, 8GB ram, Quad Xeon 2.5G+) is...
1
4460
by: Almund | last post by:
Hi, I'm trying to implement streaming over http and got stuck with a problem trying to send chunks of data using the .Net NetworkStream object. All works fine as long as I send the entire data in one invocation to the NetworkStream, like: _stream.Write(buffer, 0, buffer.Length) But if i try:
0
2570
by: meetvishu1 | last post by:
I am useing wcf with c# below is the error i found when i try to save the record twice ,at first time it works fine. It is also reproduce randomly once for the second time i hit save next time for nth time below is the description of error with stack trace , and piece of code which are having excetion. ========================================================= An existing connection was forcibly closed by the remote host Description: An...
0
9643
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look ! Part I. Meaning of...
0
9480
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
0
10313
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. Here is my compilation command: g++-12 -std=c++20 -Wnarrowing bit_field.cpp Here is the code in...
0
9946
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
1
7494
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms. Adolph will...
0
5511
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
1
4044
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
2
3643
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.
3
2875
bsmnconsultancy
by: bsmnconsultancy | last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.