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..

Thursday, March 4, 2010

Create Restore Point in Windows 7

To create a restore point in windows 7:

1-click the Start button (the windows logo round button), right-clicking Computer, and then click Properties, that will give you the system properties.

2-In the left pane, click System protection.

3-Click the System Protection tab, and then click Create.

4-It'll prompt for a description,  type a description, and then click Create.

That's It!!