All,

SQL Server 2000 SP3
Windows XP SP2

Any ideas on what's happening with this one?

I have a DTS package that loads several database tables from content in CSV
delimmited text files.  2 small lookup tables load Ok but when the task for a
larger table starts it gets about 10,000 rows into a 230,000+ row
transformation and then crashes with this error {from the DTS log}:

Step 'DTSStep_DTSDataPumpTask_3' failed

Step Error Source: Microsoft Data Transformation Services (DTS) Data Pump
Step Error Description:The number of failing rows exceeds the maximum
specified. (Microsoft Data Transformation Services (DTS) Data Pump
(80020101): Error Code: 0
Error Source= Microsoft OLE DB Provider for SQL Server
Error Description: [DBNETLIB][ConnectionOpen (Connect()).]SQL Server does
not exist or access denied.

Error on Line 8
) (Microsoft OLE DB Provider for SQL Server (80004005):
[DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access
denied.)
Step Error code: 8004206A
Step Error Help File:sqldts80.hlp
Step Error Help Context ID:0

Step Execution Started: 9/9/2005 2:28:54 PM
Step Execution Completed: 9/9/2005 2:29:26 PM
Total Step Execution Time: 32.235 seconds
Progress count in Step: 10000

How to write results of a sp/query to multiple .csv/xls files
What is SQL Server version of Oracle's CPU_PER_CALL, or how do I restrict max. exec. time of a query
SImple code error
How Do I Avoid Update Deadlock
ordered insert - select is not inserting in order