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 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:
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.
- Query to find position in a string before keyword and extract data before that position
- Correlate these tables dynamically (or automated)
- Manage the order of updates when using a filtered unique index?
- How to use an UPDATE Query with an INNER JOIN to update fields within a table
- Can we use SQL Server STRING_AGG() in queries using GROUP BY ROLLUP ()
- What are row, page and table locks? And when they are acquired?
- Aggregate into custom groups
- Work with multiple where statements with different conditions
- Excel VBA connection to SQL Server with Microsoft Entra MFA authentication
- How can I find sql server port number from windows registry?
- SSIS OLE DB Destination Editor - Create New Table not an option?
- How to Apply Gridify Filtering on an ICollection<T> in EF Core?
- SQL Server Cursor vs WHILE loop
- How do I control parameter sniffing and/or query hints in entity framework?
- Select with like is not returning the correct results
- I am trying to get the start date ONLY from the column below using a SUBSTRING. Can someone tell me what I'm doing wrong?
- using Object_id() function with #tables
- Conditionally filter results of query based on a single flag
- Fill down from a specific row based on criteria
- Spark sending LIMIT to SQL Server on display function
- database restore failing with move
- Join column from a table in SQL Server without write permissions to a data.frame in R using dbplyr
- different deleting OUTPUT behaviour based on source table
- How to simulate a deadlock in SQL Server in a single process?
- Is "SET NOCOUNT OFF" necessary in a stored procedure?
- EF Core takes a lot of time, sometimes, to perform SELECT query
- Dynamic T-SQL - Alter column definition to max length of field
- SQL Server: Update table based on JSON
- Best index(es) to use for an OR Statement in SQL Server
- In a select with a group by, get the last value of a column not in the group by