Uploading Large Table Issues

[cvasquez]

Hello everyone.
I am using SQL 2000 Server on two servers. One Local and one Remote. Everytime I upload a large table to the remote server I get a time-out error message. This only happens when I upload a large table. By being large I am talking about just 5 megs.

Has anyone come accross this problem before to resolve this issue?


Thanks a bunch;

Carlo

 

[mrdenny]

How are you uploading the data?

What's the exact error message?

How many records are you talking about?

Is there any blocking or locking going on while you are doing the load?

Denny
MCSA (2003) / MCDBA (SQL 2000)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com

(Not quite so old any more.)

 

[cvasquez]

1. I am uploading the Data using DTS
2. Error message: Error at Destination Row number 119. Errors encountered so far in this task: 1. String data, length mismatch [DBNETLIB][ConnectionWrite(send()).] General network error. Check your network documentation.
3. Total of 5,700 records
4.Is there any blocking or locking going on while you are doing the load? I am not sure where to look for this but possibly there isn't any locking. Again, this only happens with large tables.

Thanks.

Carlo

 

[mrdenny]

ok, the problem is with the data in your source table. Look at line 119. One of the fields in that row has a field where the data is two large to fit into one of the fields in your table.

Another way to see what's going on is to use the import wizzard and import the data into a new table. Then compaire the table defination of the new table to the table you were trying to import into. This should tell you what field is the wrong size.

Denny
MCSA (2003) / MCDBA (SQL 2000)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com

(Not quite so old any more.)

 

[cvasquez]

Ok I looked at the table and on that specific record and everything is ok.
I wrote down every field on a piece of paper and did a comparison witht the table I am trying to bring the data to and both tables are identical.

I also did this. I deleted the table that I am writing to and I was trying to recreate it using DTS. Guess what, it failed as well.

My next question is DNS has a lot to do with SQL 2000 server correct?

 

[mrdenny]

Nope, DNS has nothing to do with SQL Server.

Try manually creating the table and make sure that all the fields are way bigger than they need to be, and see if you can import into that table. Is there a double quote in the problem line (or the one above or below it)?

Denny
MCSA (2003) / MCDBA (SQL 2000)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com

(Not quite so old any more.)