I am doing a standard SQL Server (v2000) import using Enterprise Manager, but I am encountering an error. I am importing a small Access 2000 table to a remote hosted SQL server. If the DB has only 100 records, all goes well -- I am having it clear the table and import a fresh set of records. However, if the Access table has more records, say 4000 (still very small relative to the size it will grow to), it fails. The DTS will complete the Delete step almost instantly, but the "Copy Data" step is failing with the following error:
Error at Destination for Row number 366. Error encountered so far in this task: 1. [DBNETLIB][ConnectionWrite(send()).] General Network Error.
While I am connecting to this box over the Internet (and through a firewall), I have no problems with other tasks in Enterprise Manager, and like I said...small record sets import fine.
Any thoughts?
Thanks.