I am going bonkers trying to copy tables from one SQL Server to another. For
example, for one table, when I try to copy it from Svr A to Svr B I get the
following error:

Error at destination row number 7. Errors encountered so far in this task:
1.
{DBNETLIB]{ConnectionWrite(send()).]General Network error.

and the target table exists but is empty.

I then scripted the table and all its data and created it on Srv C by
running that script. The table looks fine and it functions correctly but if
I try to export it to Srv D (or any other server) I get the error; I've
looked through the table and everything looks OK. I ran the DBCC to check
the table and it reports no errors. I am not sure how DTS counts rows so I
can't be sure exactly what row it is referring to?

I have similar problems with several other tables. What in the world did I
screw up?

Wayne

I created a new database on my local box and if I use DTS to copy all
objects to that DB it works fine? It appears that trying to copy to any
other "real" SQL Server fails?

Wayne

"Wayne Wengert" <wayneDONTWANTSPAM (AT) wengert (DOT) com> wrote