When i run my SSIS package through sql server agent, i got the error below.
Please any one tell me abt the reason of this error
(1) I have credential created which used AD directory service account with userid and password: Userid=DONTCALL_AppPool
(2) Created a proxy which use the creddential above
(3) I used Environment variable configuration and sql server configuraion
1984-2005. All rights reserved. Started: 1:44:41 PM Error: 2010-10-01 13:44:42.16 Code: 0xC0202009 Source: DontCall Connection manager "CRBSSISConfig" 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 'CBCINTERNAL\DONTCALL_AppPool'.".
End Error Warning: 2010-10-01 13:44:42.16 Code: 0x80012059 Source: DontCall Description: Failed to load at least one of the configuration entries for the package. Check configurations
entries and previous warnings to see descriptions of which configuration failed. End Warning Error: 2
View Complete Post