Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

SQL 2000 Server DTS Job is failing unusually Expand / Collapse
Author
Message
Posted Thursday, August 30, 2012 3:44 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum 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 »

Add to briefcase

Permissions Expand / Collapse