hello experts,

i've been getting the following errors, and i have no clue as to why.
the DTS is scheduled to run at 5am and it has been failing as of
lately. when i run the dts after the error occurs, it succeeds. it
works when the SQL agent runs or when i manually run.

any help is appreciated!



************************************************** **************************************************
The execution of the following DTS Package failed:

Error Source: Microsoft Data Transformation Services (DTS) Package
Error Description:Package failed because Step
'DTSStep_DTSDataPumpTask_4' failed.
Error code: 80040428
\Error Help File:sqldts80.hlp
Error Help Context ID:1100


Package Name: DTS_YIELDBOOK_UPLOAD
Package Description: YieldBook Process
Package ID: {FB729EAC-AA03-4E5E-B89C-DA238218F262}
Package Version: {40172B77-77E5-4321-AAE6-604AA43F65A7}
Package Execution Lineage: {5E03A884-CC6E-4CCD-B03A-3948AF37161E}
Executed On: USA5BLRQN
Executed By: PortGuid_Admin
Execution Started: 10/17/2003 6:00:05 AM
Execution Completed: 10/17/2003 6:14:48 AM
Total Execution Time: 883.11 seconds

Package Steps execution information:


Step 'DTSStep_DTSExecuteSQLTask_1' succeeded
Step Execution Started: 10/17/2003 6:02:13 AM
Step Execution Completed: 10/17/2003 6:05:14 AM
Total Step Execution Time: 181.031 seconds
Progress count in Step: 0

Step 'DTSStep_DTSCreateProcessTask_1' succeeded
Step Execution Started: 10/17/2003 6:00:05 AM
Step Execution Completed: 10/17/2003 6:02:13 AM
Total Step Execution Time: 128.422 seconds
Progress count in Step: 0

Step 'DTSStep_DTSDataPumpTask_4' failed

Step Error Source: Microsoft Data Transformation Services (DTS) Data
Pump
Step Error Description:The number of failing rows exceeds the maximum
specified. (Microsoft OLE DB Provider for SQL Server (80004005):
[DBNETLIB][ConnectionWrite (WrapperWrite()).]General network error.
Check your network documentation.)
Step Error code: 8004206A
Step Error Help File:sqldts80.hlp
Step Error Help Context ID:0

Step Execution Started: 10/17/2003 6:05:14 AM
Step Execution Completed: 10/17/2003 6:08:44 AM
Total Step Execution Time: 209.953 seconds
Progress count in Step: 2000

Step 'DTSStep_DTSDataPumpTask_5' failed

Step Error Source: Microsoft Data Transformation Services (DTS) Data
Pump
Step Error Description:The number of failing rows exceeds the maximum
specified. (Microsoft OLE DB Provider for SQL Server (80004005):
[DBNETLIB][ConnectionWrite (WrapperWrite()).]General network error.
Check your network documentation.)
Step Error code: 8004206A
Step Error Help File:sqldts80.hlp
Step Error Help Context ID:0

Step Execution Started: 10/17/2003 6:05:14 AM
Step Execution Completed: 10/17/2003 6:11:26 AM
Total Step Execution Time: 371.672 seconds
Progress count in Step: 2000

Step 'DTSStep_DTSActiveScriptTask_2' succeeded
Step Execution Started: 10/17/2003 6:02:13 AM
Step Execution Completed: 10/17/2003 6:02:13 AM
Total Step Execution Time: 0.031 seconds
Progress count in Step: 0

Step 'DTSStep_DTSActiveScriptTask_3' was not executed

Step 'DTSStep_DTSExecuteSQLTask_2' was not executed

Step 'DTSStep_DTSDataPumpTask_6' failed

Step Error Source: Microsoft Data Transformation Services (DTS) Data
Pump
Step Error Description:The number of failing rows exceeds the maximum
specified. (Microsoft OLE DB Provider for SQL Server (80004005):
[DBNETLIB][ConnectionWrite (WrapperWrite()).]General network error.
Check your network documentation.)
Step Error code: 8004206A
Step Error Help File:sqldts80.hlp
Step Error Help Context ID:0

Step Execution Started: 10/17/2003 6:05:14 AM
Step Execution Completed: 10/17/2003 6:13:14 AM
Total Step Execution Time: 479.718 seconds
Progress count in Step: 0

Step 'DTSStep_DTSDataPumpTask_8' failed

Step Error Source: Microsoft Data Transformation Services (DTS) Data
Pump
Step Error Description:The number of failing rows exceeds the maximum
specified. (Microsoft OLE DB Provider for SQL Server (80004005):
[DBNETLIB][ConnectionWrite (WrapperWrite()).]General network error.
Check your network documentation.)
Step Error code: 8004206A
Step Error Help File:sqldts80.hlp
Step Error Help Context ID:0

Step Execution Started: 10/17/2003 6:05:14 AM
Step Execution Completed: 10/17/2003 6:13:36 AM
Total Step Execution Time: 501.375 seconds
Progress count in Step: 0

Step 'DTSStep_DTSDataPumpTask_1' failed

Step Error Source: Microsoft Data Transformation Services (DTS) Data
Pump
Step Error Description:The number of failing rows exceeds the maximum
specified.
(Microsoft OLE DB Provider for SQL Server (80004005):
[DBNETLIB][ConnectionWrite (WrapperWrite()).]General network error.
Check your network documentation.)
Step Error code: 8004206A
Step Error Help File:sqldts80.hlp
Step Error Help Context ID:0

Step Execution Started: 10/17/2003 6:05:14 AM
Step Execution Completed: 10/17/2003 6:14:48 AM
Total Step Execution Time: 573.562 seconds
Progress count in Step: 0

Step 'DTSStep_DTSDataPumpTask_2' was not executed

Step 'DTSStep_DTSDataPumpTask_3' was not executed

Step 'DTSStep_DTSDataPumpTask_7' was not executed

Step 'DTSStep_DTSDataPumpTask_9' was not executed

Step 'DTSStep_DTSDataPumpTask_10' was not executed

Step 'DTSStep_DTSDataPumpTask_12' was not executed

Step 'DTSStep_DTSDataPumpTask_11' was not executed
************************************************** **************************************************