x

[Closed] 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

ssislog.txt (2.9 kB)
more ▼

asked Dec 30, 2014 at 01:26 PM in Default

avatar image

nidheesh.r.pillai
9.5k 23 59 49

(comments are locked)
10|1200 characters needed characters left

The question has been closed Mar 27, 2015 at 09:34 AM by nidheesh.r.pillai for the following reason:

The question is answered, right answer was accepted


1 answer: sort voted first

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

more ▼

answered Dec 30, 2014 at 03:06 PM

avatar image

Mohanan
81 2 3

(comments are locked)
10|1200 characters needed characters left

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

SQL Server Central

Need long-form SQL discussion? SQLserverCentral.com is the place.

Topics:

x1219
x7
x4
x2

asked: Dec 30, 2014 at 01:26 PM

Seen: 969 times

Last Updated: Dec 30, 2014 at 03:06 PM

Copyright 2017 Redgate Software. Privacy Policy