Upon running a package from the 32-bit version of the dtexec.exe I am getting error as below
Please advise on how to overcome this failure. This is the command that I am using -
I have attached the logfile for reference.
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
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
answered Dec 30, 2014 at 03:06 PM