DTS Import Error...

[bartee]

I am trying to import a text file into a sql table. The text file is fixed and the table is created by sql before the import process.

I have tested the process with smaller files in the exact same format and it works fine. This file is about 65,000 rows.

When I try to import the larger file I get the following:

Error at desination for row number 5793. Errors encountered so far in this task 1. [DBNETLIB][connection write (send()).]General Network Error. Check Your Network Documentation.

There is nothing wrong with the row referrenced -- it changes with each error message (for example, it was 37,652 the next time).

Also, when I try the exact same thing on my LOCAL SQL server -- the file imports perfectly.

If anyone can help point me in the right direction in troubleshooting this it's greatly appreciated.


Thanks in advance.

 

[mrdenny]

It's some sort of network hickup. Try copying the file locally and doing the import on the server's console.

Denny
MCSA (2003) / MCDBA (SQL 2000) / MCTS (SQL 2005) / MCITP Database Administrator (SQL 2005)

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

http://www.mrdenny.com

 

[bartee]

I think your right because it works locally without issue.

Real quick, do you think it may be related to the security set up by user on the sql database?

Thanks again.

 

[mrdenny]

Nope.

Denny
MCSA (2003) / MCDBA (SQL 2000) / MCTS (SQL 2005) / MCITP Database Administrator (SQL 2005)

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

http://www.mrdenny.com