question

nidheesh.r.pillai avatar image
nidheesh.r.pillai asked

SSIS Error - Excel Connection - Class not registered

Upon running a package from the 32-bit version of the dtexec.exe I am getting error as below Error: 2014-12-30 06:58:57.22 Code: 0xC0209302 Source: Package Connection manager "Excel" Description: SSIS Error Code DTS_E_OLEDB_NOPROVIDER_ERROR. The requested OLE DB provider Microsoft.ACE.OLEDB.12.0 is not registered. Error code: 0x00000000. An OLE DB record is available. Source: "Microsoft OLE DB Service Components" Hresult: 0x80040154 Description: "Class not registered". End Error Error: 2014-12-30 06:58:57.23 Please advise on how to overcome this failure. This is the command that I am using - C:\Program Files (x86)\Microsoft SQL Server\100\DTS\Binn>dtexec.exe /FILE "\"D:\MyFolder\SSIS\Package.dtsx\"" /CONFIGFILE "\"D:\MyFolder\SSIS\Config_PackageConfig.dtsconfig\"" /CHECKPOINTING OFF /REPORTING EWCDI I have attached the logfile for reference. [SSISLOG][1] [1]: /storage/temp/ 1876-ssislog.txt
ssis2008excel-connectionclass-not-registered
ssislog.txt (2.8 KiB)
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

1 Answer

Mohanan avatar image
Mohanan answered
This is why the error is coming – When attempting to interact with Microsoft Office files, such as Excel, we need to have the right provider installed. If your server does not have MS Office 2007/2010 installed you will not have the right providers necessary to execute your SSIS package. Recommended option – Install MS Office 2007 or higher on the environment. If the case is that MS Office2007/2010 cannot be installed on the server, the only option is to install the providers directly. The providers have a smaller footprint and there are no licensing issues. MS Office 2010 (recommended) - http://www.microsoft.com/en-us/download/details.aspx?id=13255 MS Office 2007 - http://www.microsoft.com/en-us/download/details.aspx?id=23734
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.