SSIS 2012 Script Task Exception : The 'Microsoft.ACE.OLEDB.12.0' provider is not registered on the local machine

Problem :

A 64Bit Development Machine ( Win 7 x64 , because of installed SharePoint 2010 )
with Visual Studio running / debugging an SSIS 2012 Project which contains a “Script Task” that tries to retrieve data from an Excel 2010 file

While debugging the script , there is an exception

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

Solution :

They say a picture is a thousand words

In words :

Go to the property of the project >> debugging >> Set Run64BitRunTime to False

Why ?

In my case this is due to the fact that the installed version of Office 2010 is an 32 bit version, so the corresponding driver is an 32 bit one ( I have tried to install the 64bit driver , it doesn’t allow it self to be installed because of the version of the office is an 32Bit one )

Notice :

when running the package outside of the development environment on x64 computers, make sure to use the 32Bit versions of DTExec.exe and DTExecUI.exe utilities (one way to establish whether this is the case involves verifying that they are located within the Program Files (x86)\Microsoft SQL Server folder structure). In addition, when scheduling to run such packages as SQL Server Agent jobs, enable Use 32 bit runtime checkbox on the Execution options tab of the New Job Step dialog box (in the job's Properties dialog box of the SQL Server Management Studio interface).