Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Steve@CSC
Starting Member
6 Posts |
 Posted - 2002-08-06 : 10:33:42
|
| Hey guys -I'm building a DTS package which will load 60+ CSVs to a SQL 2000 database, and am getting intermittent error 1030 (DTSPackage_E_ConnectionInUse) on different tables - sometimes it'll run fine, sometimes it's one table, other times another, or several. Some runs it seems to collide with itself and just hang, requiring a Task Mgr/End Task I'm on a W2K client as well as separate W2K server, network traffic's not a problem. Each of the 40-odd CSVs I've got entered thus far only has one record, for structural integrity & data map testing. I've got Maximum Concurrent User Connections set to 0 (unlimited)Any ideas??TIA - Steve<edit>moved to correct forum</edit>Edited by - robvolk on 08/06/2002 10:47:05 |
|
|
|
|
|
DTS Package Load: Intermittent Error 1030/Hang