I have set up a SSIS Package using Business Intelligence Development Studio. The package has been running fine until a day ago. I changed nothing in the SQL Server Schedule. I am getting this error message:
Executed as user: DWPRODDB2\SYSTEM. Microsoft (R) SQL Server Execute Package Utility Version 10.50.4000.0 for 64-bit Copyright (C) Microsoft Corporation 2010. All rights reserved. Started: 11:19:55 AM Error: 2014-12-12 11:19:56.44 Code: 0xC0202009 Source: Populate Recruiter ODS Connection manager "RECRUITER_PRODUCTION" Description: SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred. Error code: 0x80040E4D. An OLE DB record is available. Source: "Microsoft SQL Server Native Client 10.0" Hresult: 0x80040E4D Description: "Login failed for user 'AD\DWPRODDB2$'.". End Error Error: 2014-12-12 11:19:56.44 Code: 0xC020801C Source: Data Flow Task - Populate SPT_REC_ACAD_HISTORY OLE DB Source - SPT_REC_ACAD_HISTORY  Description: SSIS Error Code DTS_E_CANNOTACQUIRECONNECTIONFROMCONNECTIONMANAGER . The AcquireConnection method call to the connection manager "RECRUITER_PRODUCTION" failed with error code 0xC0202009. There may be error messages posted before this with more information on why the AcquireConnection method call failed. End Error Error: 2014-12-12 11:19:56.44 Code: 0xC0047017 Source: Data Flow Task - Populate SPT_REC_ACAD_HISTORY SSIS.Pipeline Description: component "OLE DB Source - SPT_REC_ACAD_HISTORY" (1) failed validation and returned error code 0xC020801C. End Error Error: 2014-12-12 11:19:56.44 Code: 0xC004700C Source: Data Flow Task - Populate SPT_REC_ACAD_HISTORY SSIS.Pipeline Description: One or more component failed validation. End Error Error: 2014-12-12 11:19:56.45 Code: 0xC0024107 Source: Data Flow Task - Populate SPT_REC_ACAD_HISTORY Description: There were errors during task validation. End Error DTExec: The package execution returned DTSER_FAILURE (1). Started: 11:19:55 AM Finished: 11:19:56 AM Elapsed: 0.733 seconds. The package execution failed. The step failed.