There is SQL agent job that runs a SSIS package once a day, but for the last few days its been failing. As far as I can tell nothing has changed. The Database name is 'Greece'
The error message is:
Executed as user: S2\ServiceAccount. ...9.00.4035.00 for 64-bit Copyright (C) Microsoft Corp 1984-2005. All rights reserved. Started: 10:14:18 Error: 2010-09-13 10:14:49.36 Code: 0xC0202009
Source: NL LCDB Import Products Connection manager "Greece.eu.LB.com,10563.msdb.BNLSQL" 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 Native Client" Hresult: 0x80040E4D Description: "Login failed for user 'BNLSQL'.". End Error Error: 2010-09-13 10:14:49.36 Code: 0xC020801C Source: NL LCDB Import
Products Log provider "NL LCDB Import Products" Description: SSIS Error Code DTS_E_CANNOTACQUIRECONNECTIONFROMCONNECTIONMANAGER. The AcquireConnection method call to the connection manager "Greece.eu.LB.com,10563.msdb.BNLSQL"
failed with error code 0xC0202009. There may be error messages
View Complete Post