[DBNETLIB][ConnectionWrite(send())]General network error.

This used to sporadically happen when DTS'ing data from a local sql server
to our production server. Now it's consistent. Local SQL Server is running
SQL Server 2000 SP4 and Production Server is running 2000 SP4. Now, the only
way for me to get data uploaded is to extract the data from my local server
into a text file, copy it up to a server location, login to terminal server
and then dts my data in. Data has to be cleaned up before it can go to the
production server. Hence, working with it locally. Any would be
appreciated as I have to do this very often.

On Jun 17, 11:59 am, Leanne <Lea...@discussions.microsoft.com> wrote:
> [DBNETLIB][ConnectionWrite(send())]General network error.
>
> This used to sporadically happen when DTS'ing data from a local sql server
> to our production server. Now it's consistent. Local SQL Server is running
> SQL Server 2000 SP4 and Production Server is running 2000 SP4. Now, the only
> way for me to get data uploaded is to extract the data from my local server
> into a text file, copy it up to a server location, login to terminal server
> and then dts my data in. Data has to be cleaned up before it can go to the
> production server. Hence, working with it locally. Any would be
> appreciated as I have to do this very often.

Something is happening on your network that caused the connection
between the two to reset. Have your Windows admin and Network people
check your network settings and look at the windows error logs as
well. If your a small shop, then you'll have to do it yourself if you
are comfortable doing so. Make sure one of the machines is not
rebooting in the middle of the process. We had a group policy thing
that caused me that issue once as well.

How big are the tables? how much data are we talking?

We had this problem and one way to limit our exposure was in DTS, set
your batch size to something other than 0. This way it does it in
chunks.

you'll be surprised how many people have that non descriptive error.

Good luck!

David