CODEWITHSUNDEEP
ssis-2008
Miguel T
Miguel T

Reputation: 1

SSIS - Driver Error after upgrading to office 2013

I'm running SSIS 2008 with .Net Framework 3.5 SP1 on a Windows7 machine.

I upgrade from office 2007 to office 2013 and start getting the following driver error while importing from xlsx files: "The 'Microsoft.ACE.OLEDB.12.0' provider is not registered on the local machine"

I then install Microsoft Data Connectivity Components and now, the problem seems to be solved, but every time I run a data flow with excel source or destination I get a message box with the following: "The setup controller has encountered a problem during install. Please review the log files for further information"

It's just a message, but the process stops and I need do click the "Ok" button so the dtsx continue running.

Any help on this would be great.

Many thanks

Upvotes: 0

Views: 165

Answers (1)

rtraees
rtraees

Reputation: 332

I face the same problem while working on .Net Application in which I am using Microsoft Access Database. Whenever I run application it encounter the same error "Setup Error the setup controller has encountered a problem during install. Please review the log file". I found solution in an Article . You just have to rename or delete following folders

  • c:/program files/common files/microsoft shared/office 14/office setup controller
  • c:/program files/common files/microsoft shared/office 12/office setup controller

Upvotes: 0

Related Questions