February 5, 2015 at 6:06 am
Hi,
I'm trying to use Excel in SSIS to import the data from spreadsheet to a staging table. The package runs well from the web server using SSMS. But when I deploy and try to execute the package, I'm getting the below error. I've a question, whether I've to install the AccessDatabaseEngine driver in SQL database server or the web server where I'm executing the SSIS?
Error: The requested OLE DB provider Microsoft.Jet.OLEDB.4.0 is not registered. If the 64-bit driver is not installed, run the package in 32-bit mode.
February 5, 2015 at 11:23 am
Your server needs this driver installed to read excel file.
http://www.microsoft.com/en-us/download/details.aspx?id=23734
February 5, 2015 at 12:35 pm
Thank you for your reply. I've one more questions. I've install the driver in the server where SQL 2012 "server version" is installed or at client system? I'm executing the SSIS from client and I installed the Office 2010 driver in client system.
February 5, 2015 at 12:48 pm
NSB (2/5/2015)
Thank you for your reply. I've one more questions. I've install the driver in the server where SQL 2012 "server version" is installed or at client system? I'm executing the SSIS from client and I installed the Office 2010 driver in client system.
You install it on the server where sql server is installed.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply