dbTalk Databases Forums  

Problem of SQL Server 2000 SP3a

microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts


Discuss Problem of SQL Server 2000 SP3a in the microsoft.public.sqlserver.dts forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Poonpipat
 
Posts: n/a

Default Problem of SQL Server 2000 SP3a - 11-08-2004 , 08:38 PM






I had exported data between SQLServer2000
by
Source server was SQL Server 2000 any version
Destination server was SQL Server 2000 SP3a

I had data of 120,000 rows to export.
Between I was exporting data. An error occur and the message was
"Error at Destination for Row number 28649. Errors encountered so far in
this task: 1.[DBNETLIB][ConnectionWrite(send()).]General network error. Check
your network documentation"

How do I fixed this problem?
Or this is a bug of SQLServer



Reply With Quote
  #2  
Old   
Allan Mitchell
 
Posts: n/a

Default Re: Problem of SQL Server 2000 SP3a - 11-09-2004 , 12:15 AM






OK

To me sounds like your connection (Network) went down.

Are you doing this inter-server?

--

Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.SQLDTS.com - The site for all your DTS needs.
www.Konesans.com


"Poonpipat" <Poonpipat (AT) discussions (DOT) microsoft.com> wrote

Quote:
I had exported data between SQLServer2000
by
Source server was SQL Server 2000 any version
Destination server was SQL Server 2000 SP3a

I had data of 120,000 rows to export.
Between I was exporting data. An error occur and the message was
"Error at Destination for Row number 28649. Errors encountered so far in
this task: 1.[DBNETLIB][ConnectionWrite(send()).]General network error.
Check
your network documentation"

How do I fixed this problem?
Or this is a bug of SQLServer





Reply With Quote
  #3  
Old   
Poonpipat
 
Posts: n/a

Default Re: Problem of SQL Server 2000 SP3a - 11-09-2004 , 12:38 AM



No , I tranfered data between Server by using Local Area Network(LAN) of my
company.


"Allan Mitchell" wrote:

Quote:
OK

To me sounds like your connection (Network) went down.

Are you doing this inter-server?

--

Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.SQLDTS.com - The site for all your DTS needs.
www.Konesans.com


"Poonpipat" <Poonpipat (AT) discussions (DOT) microsoft.com> wrote in message
news:EF479B71-3B08-4C8F-B073-7718306390CE (AT) microsoft (DOT) com...
I had exported data between SQLServer2000
by
Source server was SQL Server 2000 any version
Destination server was SQL Server 2000 SP3a

I had data of 120,000 rows to export.
Between I was exporting data. An error occur and the message was
"Error at Destination for Row number 28649. Errors encountered so far in
this task: 1.[DBNETLIB][ConnectionWrite(send()).]General network error.
Check
your network documentation"

How do I fixed this problem?
Or this is a bug of SQLServer






Reply With Quote
  #4  
Old   
Allan Mitchell
 
Posts: n/a

Default Re: Problem of SQL Server 2000 SP3a - 11-09-2004 , 12:54 AM



Yes but Server --> Server i.e. not on the same server?

--

Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.SQLDTS.com - The site for all your DTS needs.
www.Konesans.com


"Poonpipat" <Poonpipat (AT) discussions (DOT) microsoft.com> wrote

Quote:
No , I tranfered data between Server by using Local Area Network(LAN) of
my
company.


"Allan Mitchell" wrote:

OK

To me sounds like your connection (Network) went down.

Are you doing this inter-server?

--

Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.SQLDTS.com - The site for all your DTS needs.
www.Konesans.com


"Poonpipat" <Poonpipat (AT) discussions (DOT) microsoft.com> wrote in message
news:EF479B71-3B08-4C8F-B073-7718306390CE (AT) microsoft (DOT) com...
I had exported data between SQLServer2000
by
Source server was SQL Server 2000 any version
Destination server was SQL Server 2000 SP3a

I had data of 120,000 rows to export.
Between I was exporting data. An error occur and the message was
"Error at Destination for Row number 28649. Errors encountered so far
in
this task: 1.[DBNETLIB][ConnectionWrite(send()).]General network error.
Check
your network documentation"

How do I fixed this problem?
Or this is a bug of SQLServer








Reply With Quote
  #5  
Old   
Poonpipat
 
Posts: n/a

Default Re: Problem of SQL Server 2000 SP3a - 11-11-2004 , 04:09 AM



Yes, the server that I tranfer data is not the same server

"Allan Mitchell" wrote:

Quote:
Yes but Server --> Server i.e. not on the same server?

--

Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.SQLDTS.com - The site for all your DTS needs.
www.Konesans.com


"Poonpipat" <Poonpipat (AT) discussions (DOT) microsoft.com> wrote in message
news:B358A5E5-D9CD-48E8-A66E-6127E32C41C7 (AT) microsoft (DOT) com...
No , I tranfered data between Server by using Local Area Network(LAN) of
my
company.


"Allan Mitchell" wrote:

OK

To me sounds like your connection (Network) went down.

Are you doing this inter-server?

--

Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.SQLDTS.com - The site for all your DTS needs.
www.Konesans.com


"Poonpipat" <Poonpipat (AT) discussions (DOT) microsoft.com> wrote in message
news:EF479B71-3B08-4C8F-B073-7718306390CE (AT) microsoft (DOT) com...
I had exported data between SQLServer2000
by
Source server was SQL Server 2000 any version
Destination server was SQL Server 2000 SP3a

I had data of 120,000 rows to export.
Between I was exporting data. An error occur and the message was
"Error at Destination for Row number 28649. Errors encountered so far
in
this task: 1.[DBNETLIB][ConnectionWrite(send()).]General network error.
Check
your network documentation"

How do I fixed this problem?
Or this is a bug of SQLServer









Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.