SSIS: OLEDB.12.0 provider is not registered

Problem:

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.

Solution:

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!