Execute SQL Task Description: Failed to acquire connection “Local server connection”. Connection may not be configured correctly or you may not have the right permissions on this connection. End Error Warning: 2016-09-05 17:00:01.26 Code: 0x80019002 Source: OnPreExecute Description: SSIS Warning Code DTS_W_MAXIMUMERRORCOUNTREACHED. The Execution method succeeded, but the number of errors raised (1) reached the maximum allowed (1); resulting in failure. This occurs when the number of errors reaches the number specified in MaximumErrorCount. Change the MaximumErrorCount or fix the errors. End Warning Error: 2016-09-05 17:00:01.29 Code: 0xC0024104 Source: Maintenance Cleanup Task … The package execution fa… The step failed.
The issue is with connecting the sql server . Check the connection defined in the maintenance plan. Mostly the connection may get broken. If not able to edit the connection , create the new plan and define again and drop the old plan.