From bids package executing successfully (Manually)
Executing ssis package from asp.net page when I tried to run by clicking execute package on page am getting below error.
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 'NT AUTHORITY\ANONYMOUS LOGON'.". SSIS Error Code DTS_E_CANNOTACQUIRECONNECTIONFROMCONNECTIONMANAGER. The AcquireConnection method call to the connection manager "STAGING" failed with error code 0xC0202009. There may be error messages posted before this with more information on why the AcquireConnection method call failed. component "Lookup 1" (2791) failed validation and returned error code 0xC020801C. One or more component failed validation.
There were errors during task validation.
User contributions licensed under CC BY-SA 3.0