[Fix] - SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred

Wikitechy | 11762 Views | sql server | 08 Jun 2016

 

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 1.1 (16 bit)
  • SQL Server 4.2A (16 bit)
  • SQL Server 4.2B (16 bit)
  • SQL Server 4.21a
  • SQL Server 6.0
  • SQL Server 6.5
  • SQL Server 7.0
  • SQL Server 7.0 OLAP Tools
  • SQL Server 2000
  • SQL Server 2000 64-bit Edition
  • SQL Server 2005
  • SQL Server 2008
  • Azure SQL DB
  • SQL Server 2008 R2
  • SQL Server 2012
  • SQL Server 2014
  • SQL Server 2016

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




Workshop

Bug Bounty
IOT Hackathon
Webinar

Join our Community

Advertise