February 7, 2020 at 7:47 pm
Hello,
I am trying to create a SSIS package that takes data from an MS SQL Server 2016 database (running on Windows Server 2016) and exports it as an Excel 2013 spreadsheet. As I step though the Data Export Wizard and select the output file format I get the following error.
"The 'Microsoft.ACE.OLEDB.15.0' provider is not registered on the local machine."
Can someone point me in the right direction to solve this issue? A Google search provided lots of results but not really anything describing my specific issue.
February 7, 2020 at 8:15 pm
You need to install the ACE driver if you haven’t already done so wherever your going to be running this package.
There is a 32bit and 64bit version so you need to ensure you are running the package in the right runtime for the driver you have installed.
February 10, 2020 at 8:54 am
Just download and install the correct Microsoft Access Database Engine 2016 Redistributable file.
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
February 19, 2020 at 4:01 pm
I downloaded and installed the 64 bit version of the Microsoft Access Database Engine 2016 Redistributable file but I am still getting the same error message. This happens in the 32 and 64 bit version of the Data Export Wizard.
February 19, 2020 at 4:52 pm
If you're using SSIS, I assume Visual Studio, you need to download and install the 32bit version. Visual Studio is still only a 32bit application, so only supports the 32 drivers.
You'll need to uninstall the 64bit drivers first, before you can install the 32bit drivers.
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
February 19, 2020 at 6:06 pm
Thank you!!
Installing the 32 bit version and setting the package execution option to 32 bit solved the problem.
Thanks again!!
February 19, 2020 at 7:03 pm
If you're using SSIS, I assume Visual Studio, you need to download and install the 32bit version. Visual Studio is still only a 32bit application, so only supports the 32 drivers.
You'll need to uninstall the 64bit drivers first, before you can install the 32bit drivers.
Actually - you can have both the 32bit and 64bit versions installed at the same time. To perform the installation of the other version you just need to use the /passive or /quiet command line option (depends on which version driver you are installing).
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply