Error Ehile Executing DTS task

#1

I got an error while trying to DTS a large text file 13GB large- the error
message is "Error at Destination Row Number 20331257. Errors encountered so
far in this task is 1.
[DBNETLIB][ConnectionRead (recv()).] General Network error. Check your
network Documentation."

Any suggestions?

#2

Hello SJ,

It would appear that there was a network glitch. Is the file on a different
server to the Database?

Allan

Quote:

I got an error while trying to DTS a large text file 13GB large- the
error
message is "Error at Destination Row Number 20331257. Errors
encountered so
far in this task is 1.
[DBNETLIB][ConnectionRead (recv()).] General Network error. Check your
network Documentation."
Any suggestions?

#3

Yes - the text file is in a server different from the SQLServer DB.

"Allan Mitchell" wrote:

Quote:

Hello SJ,

It would appear that there was a network glitch. Is the file on a different
server to the Database?

Allan

I got an error while trying to DTS a large text file 13GB large- the
error
message is "Error at Destination Row Number 20331257. Errors
encountered so
far in this task is 1.
[DBNETLIB][ConnectionRead (recv()).] General Network error. Check your
network Documentation."
Any suggestions?

#4

Hello SJ,

Then it sounds as though communication was lost betwen the two. FTP or zip
and move the file to the SQL Server? This might prove to be quicker.

Allan

Quote:

Yes - the text file is in a server different from the SQLServer DB.

"Allan Mitchell" wrote:

Hello SJ,

It would appear that there was a network glitch. Is the file on a
different server to the Database?

Allan

I got an error while trying to DTS a large text file 13GB large- the
error
message is "Error at Destination Row Number 20331257. Errors
encountered so
far in this task is 1.
[DBNETLIB][ConnectionRead (recv()).] General Network error. Check
your
network Documentation."
Any suggestions

#5

Will try and let you know.
Thank you,

"Allan Mitchell" wrote:

Quote:

Hello SJ,

Then it sounds as though communication was lost betwen the two. FTP or zip
and move the file to the SQL Server? This might prove to be quicker.

Allan

Yes - the text file is in a server different from the SQLServer DB.

"Allan Mitchell" wrote:

Hello SJ,

It would appear that there was a network glitch. Is the file on a
different server to the Database?

Allan

I got an error while trying to DTS a large text file 13GB large- the
error
message is "Error at Destination Row Number 20331257. Errors
encountered so
far in this task is 1.
[DBNETLIB][ConnectionRead (recv()).] General Network error. Check
your
network Documentation."
Any suggestions?

#6

Load finished in less than an hour without an issue when I loaded from the
server.
Thank you,

"SJ" wrote:

Quote:

Will try and let you know.
Thank you,

"Allan Mitchell" wrote:

Hello SJ,

Then it sounds as though communication was lost betwen the two. FTP or zip
and move the file to the SQL Server? This might prove to be quicker.

Allan

Yes - the text file is in a server different from the SQLServer DB.

"Allan Mitchell" wrote:

Hello SJ,

It would appear that there was a network glitch. Is the file on a
different server to the Database?

Allan

I got an error while trying to DTS a large text file 13GB large- the
error
message is "Error at Destination Row Number 20331257. Errors
encountered so
far in this task is 1.
[DBNETLIB][ConnectionRead (recv()).] General Network error. Check
your
network Documentation."
Any suggestions?

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Error Ehile Executing DTS task

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

Error Ehile Executing DTS task - 10-13-2005 , 02:31 PM

Re: Error Ehile Executing DTS task - 10-13-2005 , 02:40 PM

Re: Error Ehile Executing DTS task - 10-13-2005 , 03:07 PM

Re: Error Ehile Executing DTS task - 10-13-2005 , 03:39 PM

Re: Error Ehile Executing DTS task - 10-13-2005 , 03:55 PM

Re: Error Ehile Executing DTS task - 10-18-2005 , 10:17 AM