OLE DB provider SQLNCLI.1 is not registered

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

http://www.microsoft.com/en-us/download/details.aspx?id=29065

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.

Advertisements
Tagged with: ,
Posted in Development
One comment on “OLE DB provider SQLNCLI.1 is not registered
  1. Erik says:

    This is the only answer that I’ve found out there that actually works. Much appreciated! Switching the 64 bit flag does nothing as well as reloading the latest Data Access Layer patch.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: