January 23, 2007 at 8:41 am
I am having trouble copying a table with DTS. I am trying to copy a table to another database but it continues to fail at different row numbers? I get this error message back.
ErrorMessage: Error at Destination for Row number 14131. Errors encountered so far in this task: 1. [DBNETLIB][ConnectionRead (recv()).]General network error. Check your network documentation.
Any ideas on what the problem could be?
January 25, 2007 at 6:06 am
This is typically indicating a network connection error. The first thing to do is take as much ot of the picture as possible. If you can use terminal services or sit at the console of your server and create and run the DTS package from there you would eliminate a lot of variables. You may also want to change the types of connections your server will accept, if you are using named pipes, switch to TCP/IP or do the reverse to see if it eliminates the problem. These can all help indicate the actual source.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply