SQL 2000 Server DTS Job is failing unusually

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 7,2000 » General » SQL 2000 Server DTS Job is failing unusually

SQL 2000 Server DTS Job is failing unusually

Rate Topic

Display Mode

Topic Options

Author

Message

khaleel57

Posted Thursday, August 30, 2012 3:44 AM

Forum Newbie

Group: General Forum Members
Last Login: Thursday, September 20, 2012 6:59 AM
Points: 1, Visits: 4

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

Post #1352078

« Prev Topic | Next Topic »

Permissions