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.
Categories: SSIS

Related Posts


SSIS Lookup Transformation – Handle Case Sensitive Issue

Problem: I have a lookup transformation in one of my SSIS packages, used it to get ID of an employee record in a dimension table. However my problem is that some of the source data Read more…