Wednesday, February 13, 2013

SSIS: OLEDB.12.0 provider is not registered

Today I tried to develop a simple SSIS package to populate the data to excel file using Excel Destination of SSIS components, but It throws the below error when I select excel sheet in Excel Destination Editor.

The 'Microsoft.ACE.OLEDB.12.0' provider is not registered on the local machine.

This issue is resolved by installing 2007 Office System Driver: Data Connectivity Components

To install this download:
  1. Download the file by clicking the "Data Connectivity Components" link (above) and saving the file to your hard disk.
  2. Double-click the AccessDatabaseEngine.exe program file on your hard disk to start the setup program.
  3. Follow the instructions on the screen to complete the installation.
Hope this helps!

No comments:

Post a Comment