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:
- Download the file by clicking the “Data Connectivity Components” link (above) and saving the file to your hard disk.
- Double-click the AccessDatabaseEngine.exe program file on your hard disk to start the setup program.
- Follow the instructions on the screen to complete the installation.