title: SSIS: The requested OLE DB provider SQLNCLI10.1 is not registered
body: <p>I'm trying to update my ETL jobs on a new reporting server and I got this error:</p>
  
  <blockquote>
    <p>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<br>
    Description:
    Consider changing the PROVIDER in the connection string to SQLNCLI11
    or visit <a href="http://www.microsoft.com/downloads" rel="nofollow noreferrer">http://www.microsoft.com/downloads</a> to find and install
    support for SQLNCLI10.1.  End Error  Error: 2016-12-28 15:44:22.24<br>
    Code: 0xC020801C     Source: Load Stage OLE DB Source [149]    </p>
  </blockquote>
  
  <p>I tried changing the provider in my config file to <strong>SQLNCLI11</strong> as it suggests which seemed to fix the problem for others but I am still getting the same error.</p>
  
  <p><strong>Drivers on report server:</strong></p>
  
  <p><a href="https://i.stack.imgur.com/V08qJ.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/V08qJ.png" alt="enter image description here"></a></p>