Click here to monitor SSC
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in
Home       Members    Calendar    Who's On

Add to briefcase

Toubleshooting of DTSX Error Msg Expand / Collapse
Posted Wednesday, January 22, 2014 4:07 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Wednesday, January 22, 2014 9:42 PM
Points: 1, Visits: 4

I need to troubleshooting of belwo mention error screenshot.

01/21/2014 02:00:00,MaintenancePlan.Full back up,Error,0,SRCSRV45VOC08,MaintenancePlan.Full back up,(Job outcome),,The job failed. The Job was invoked by Schedule 16 (MaintenancePlan.Full back up). The last step to run was step 1 (Full back up).,00:00:35,0,0,,,,0
01/21/2014 02:00:00,MaintenancePlan.Full back up,Error,1,SRCSRV45VOC08,MaintenancePlan.Full back up,Full back up,,Executed as user: SRCSRV45VOC08\administrator. Microsoft (R) SQL Server Execute Package Utility Version 10.0.5500.0 for 64-bit Copyright (C) Microsoft Corp 1984-2005. All rights reserved. Started: 2:00:00 AM Progress: 2014-01-21 02:00:23.78 Source: {BC282841-8E66-4C1E-94AB-35F916017BF8} Executing query "DECLARE @Guid UNIQUEIDENTIFIER EXECUTE msdb..sp...".: 100% complete End Progress Error: 2014-01-21 02:00:28.89 Code: 0xC002F210 Source: Maintenance Cleanup Task Execute SQL Task Description: Executing the query "EXECUTE master.dbo.xp_delete_file 0<c/>N'\\" failed with the following error: "xp_delete_file() returned error 2<c/> 'The system cannot find the file specified.'". Possible failure reasons: Problems with the query<c/> "ResultSet" property not set correctly<c/> parameters not set correctly<c/> or connection not established correctly. End Error DTExec: The package execution returned DTSER_FAILURE (1). Started: 2:00:00 AM Finished: 2:00:33 AM Elapsed: 32.198 seconds. The package execution failed. The step failed.,00:00:35,0,0,,,,0

Post #1533542
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse