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

11 בנובמבר 2012

תגובה אחת

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

הוסף תגובה
facebook linkedin twitter email

כתיבת תגובה

האימייל לא יוצג באתר. שדות החובה מסומנים *

תגובה אחת

  1. Sexton14 בנובמבר 2012 ב 16:59

    I usually do not leave many remarks, however after
    looking at through a lot of responses on SSIS 2012 Script Task Exception
    : The 'Microsoft.ACE.OLEDB.12.0' provider is not registered on the local machine – Adlai Maschiach.
    I do have a couple of questions for you if it's okay. Is it just me or do a few of these remarks look like they are left by brain dead people? 😛 And, if you are writing at additional social sites, I would like to follow you. Could you list of all of all your public sites like your Facebook page, twitter feed, or linkedin profile?