Thursday, March 18, 2010

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

Hi, ever tried to read or write to an excel file and got that error? 
"The 'Microsoft.ACE.OLEDB.12.0' provider is not registered on the local machine."

Well it just happened to me today, I just got a freshly built machine, windows 7 ultimate 64BIT, 12 GB RAM, and Office 2010 installed.

Anyway after investigating the issue, just make sure and load the 2007 Office System Driver: Data Connectivity Components from:


That solved the issue for me..