Blog Post

SQL Server Support Blog
7 MIN READ

SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred :- Reasons and troubleshooting.

Krishnakumar_Rukmangathan's avatar
Krishnakumar_Rukmangathan
Icon for Microsoft rankMicrosoft
Jan 15, 2019
First published on MSDN on Nov 09, 2009 This is a very generic error and can occur due to multiple reasons. I am documenting as much as of them based on Case studies. Refer...
Updated Jan 15, 2019
Version 2.0
Integration Services(SSIS)
abhijeetjpatil's avatar
abhijeetjpatil
Copper Contributor
May 23, 2021

Hi all,

I am facing somewhat similar error:

 

Error in Microsoft.SqlServer.Dts.Runtime.Package/Connection manager "[Data-Base-Name]” : 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 11.0" Hresult: 0x80004005 Description: Login timeout expired."

An OLE DB record is available. Source "Microsoft SQL Server Native Client 11.0" Hresult: 0x80004005 Description: "A network-related or instance -specific error has occurred while establishing a connection to SQL server. Server is not found or not accessible. Check if instance name is correct and if SQL Server is configured to allow remote connection. For more information see SQL Server Books online.".

An OLE DB record is available. Source "Microsoft SQL Server Native Client 11.0" Hresult: 0x80004005 Description: "SQL Server Network Interfaces: Error Locating Server/Instance Specified [xFFFFFFFF].".

Error in Microsoft.SqlServer.Dts.Runtime.TaskHost/Execute SQL Task : Failed to acquire connection "[Data-Base-Name]”. Connection may not be configured correctly or you may not have the right permission on this connection.

 

I am developing SISS packages in Visual Studio  2017 (with SSMS 2017) on Windows-10 machine and connecting to Microsoft SQL Server 2014 (SP3-CU-GDR) (KB4535288) – 12.0.6372.1 (X64). It works without any error.

 

When I run this SSIS package ( as Deploy to the file system) on Windows 2016 server, they fail with above error.

My setup on server:

  • Windows-2016 server
  • SQL Server Management Studio 2016

  • SQL Server Integration Services 13.0 (SSIS service)

  • Connecting to Microsoft SQL Server 2014 (SP3-CU-GDR) (KB4535288) – 12.0.6372.1 (X64) 
  • Using same user ID and password that I use on Windows-10 machine as well as connecting via SSMS 2016 (on Win-2016 server)
  • On Windows-2016 TLS 1.2 is enabled.

Any pointers to what I am missing here or any article on web that you may now would greatly help.

Thank you