如何注册OLE DB provider Microsoft.ACE.OLEDB.12.0,我的SSIS中的Excel连接管理器显示报错没有注册类，如何解决这个报错？

Solved - The Microsoft.ACE.OLEDB.12.0 provider is not registered on the local machine (mikesdotnetting.com)

  Visual Studio is only available as a 32-bit application. If you try to connect to Access from within Visual Studio, you must have a 32-bit version of ACE installed.

  The same is true of SQL Server Data Tools, which you might use for creating SSIS packages. For other applications, you should check the bit-ness to ensure that you have an appropriate version of the provider installed.

   As I have already mentioned, it is perfectly possible to have both a 32-bit and a 64-bit version installed at the same time, so long as they are not both from the 2010 download site.

The second option is to change the application pool in IIS to enable 32-bit applications. If you are using the full version of IIS, you can use the management tool to do this

(Control Panel » Administrative Tools » Internet Information Services (IIS) Manager).