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


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 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

asked on Stack Overflow Dec 28, 2016 by Jonathan Porter • edited Dec 29, 2016 by Jonathan Porter

3 Answers


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

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

answered on Stack Overflow Jul 21, 2017 by GianniB

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