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 
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 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.
User contributions licensed under CC BY-SA 3.0