SQL 2000 Server DTS Job is failing unusually

• khaleel57

  Newbie

  Points: 9

  More actions

  August 30, 2012 at 3:44 am

  #151056

  Hi All,

  One of my DTS job scheduled for daily run, the job having collection of packages like task1, task2 etc.

  task2 having stored procedure. DTS job runs daily at 4 am and sometimes one unusual error occurring for us not regularly i.e task2( package SP) is failed.

  Error log message is as below:

  ------------------------------------------------------------------------

  Step 'DTSStep_DTSExecuteSQLTask' failed

  Step Error Source: Microsoft OLE DB Provider for SQL Server

  Step Error Description:Sort failure.

  Step Error code: 80004005

  Step Error Help File:

  Step Error Help Context ID:0

  Step Execution Started: 8/30/2012 4:08:22 AM

  Step Execution Completed: 8/30/2012 4:32:00 AM

  Total Step Execution Time: 1416.203 seconds

  Progress count in Step: 0

  -------------------------------------------------

  Please give any idea on this error how to avoid this and let me know if any further information is required.

  Regards,

  Shaik