This question was
closed
by
nidheesh.r.pillai for the following reason: The question is answered, right answer was accepted
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
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
14 People are following this question.
