[Fix] - SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred
Scenario :
- SSIS package executing a data conversion task.
Error :
Code: 0xC0202009
Source: Connection manager ""
Description: SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred. Error code: 0x80004005.
An OLE DB record is available. Source: "Microsoft SQL Server Native Client 10.0" Hresult: 0x80004005 Description: "Cannot generate SSPI context".
Reason for the error :
- The error occurs when providing invalid credentials to access a database.
Fix 1 :
- Ensure that the SQL user creation process is complete with "password never expires" settings. If the answer is no, then the password of the user is expired and hence causing an authentication error in Integration Services packages.
- Hence the better solution is to execute the SSIS package after modifying the account settings in Active Directory Users of Windows, with never expiring password.
Fix 2 :
- Generate a proxy credential by integrating windows authentication in the job step that triggers the SSIS package to use the configured credential as follows:
Applies to sqlserver version :
- SQL Server 7.0 OLAP Tools
- SQL Server 2000 64-bit Edition
Related Tags :
- sql server - how to resolve DTS_E_OLEDBERROR. in ssis
- SSIS Package failes with OLE DB error
- sql server - SSIS OLE DB Error on package execution
- SSIS Error Code DTS_E_OLEDBERROR.An OLE DB error has occurred.
- sql server - SSIS OLE DB Error on package execution -SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred
- Error - SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occured.
- ssis error code dts_e_oledberror. an ole db error has occurred. error code 0x80040e37