Maintainance Job is failing in SQL Server 2008 R2 Standard Edition

0

Maintainance job is failing in SQL Server 2008 R2 Standard Edition with the error shown below. Could you please tell me can we set up a maintenance job in SQL Server 2008 R2?

Error:

Executed as user:
Microsoft (R) SQL Server Execute Package Utility Version 10.50.4000.0 for 32-bit
Copyright (C) Microsoft Corporation 2010. All rights reserved.

Started: 2:36:11 AM Could not load package "\Maintenance Plans\cIMSStaging2IndexRebuild" because of error 0xC0014062.

Description: The LoadFromSQLServer method has encountered OLE DB error code 0x80004005 (Login timeout expired).
The SQL statement that was issued has failed.
Source: Started: 2:36:11 AM Finished: 2:36:54 AM Elapsed: 43.281 seconds.
The package could not be loaded. The step failed.

sql-server
ssis
asked on Stack Overflow Nov 29, 2019 by venu siripuram • edited Nov 29, 2019 by marc_s

0 Answers

Nobody has answered this question yet.


User contributions licensed under CC BY-SA 3.0