If you get the following error while trying to run an SSIS package on SQL Server 2012.
The requested OLE DB provider SQLNCLI.1 is not registered. If the 64-bit driver is not installed, run the package in 32-bit mode. error code: 0x00000000.
It looked like installing the Sql Server 2012 feature pack
would do the trick, but I reinstalled the Sql Server Native Client and it did not work. Instead, I changed the provider to “OLE DB Provider for SQL Server” and that worked. It changed the provider to SQLOLEDB.1 which was already available on the system.