SSIS: The requested OLE DB provider SQLNCLI10.1 is not registered

1

I'm trying to update my ETL jobs on a new reporting server and I got this error:

Microsoft (R) SQL Server Execute Package Utility Version 13.0.1601.5 for 64-bit Copyright (C) 2016 Microsoft. All rights reserved. Started: 3:44:21 PM Error: 2016-12-28 15:44:22.24 Code: 0xC0209303 Source: FactCOGS Connection manager "MyConnection" Description: The requested OLE DB provider SQLNCLI10.1 is not registered. If the 64-bit driver is not installed, run the package in 32-bit mode. Error code: 0x00000000. An OLE DB record is available. Source: "Microsoft OLE DB Service Components" Hresult: 0x80040154 Description: "Class not registered". End Error Error: 2016-12-28 15:44:22.24 Code: 0xC020F42A
Description: Consider changing the PROVIDER in the connection string to SQLNCLI11 or visit http://www.microsoft.com/downloads to find and install support for SQLNCLI10.1. End Error Error: 2016-12-28 15:44:22.24
Code: 0xC020801C Source: Load Stage OLE DB Source [149]

I tried changing the provider in my config file to SQLNCLI11 as it suggests which seemed to fix the problem for others but I am still getting the same error.

Drivers on report server:

enter image description here

sql-server
configuration
ssis
configuration-files
asked on Stack Overflow Dec 28, 2016 by Jonathan Porter • edited Dec 29, 2016 by Jonathan Porter

3 Answers

1

I had to finish this today so I ended up installing the SQLNCLI10 drivers on the new report server and everything worked again. If I find a better solution in the future I will update my answer.

answered on Stack Overflow Dec 29, 2016 by Jonathan Porter
0

Edit the job step. Go to "Execution options". Try checking "Use 32 bit runtime" option.

answered on Stack Overflow Jul 21, 2017 by GianniB
0

I got the same message running a SSIS DTSX Package created on Visual Studio 2008 and deployed on SQL Server 10.50.6560. I fixed the problem by going to the SSIS Solution Properties -> Debugging -> Debug Options -> Run64BitRuntime -> Set to TRUE. It workout just fine, hope it helps.

answered on Stack Overflow May 23, 2019 by Jesus F. Leon

User contributions licensed under CC BY-SA 3.0