• Help required on below error,

    1. Error: SSIS Error Code DTS_E_CANNOTACQUIRECONNECTIONFROMCONNECTIONMANAGER. The AcquireConnection method call to the connection manager " scan.IEDB" failed with error code 0xC0202009. There may be error messages posted before this with more informatino on

    2. Why the AcquireConnection method call failed

    3. Error: component " OLE DB Source" (2042) failed validation and returned error code 0xC020801C.

    4. Error: One or more component failed validation

    5. Error: There were errors during task validation.

    6. Error: SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occured. Error Code: 0x80040E4D. An OLE DB record is available. Source: "Microsoft SQL Server Native Client 10.0" Hresult: 0x80040E4D Description: "Login failed for user 'release'.".