Did you install the ACE driver on the machine where you have SQL Server?
Setting up SQL Job to Auto Run SSIS Package from Integration Services: Says missing driver
I created an SSIS Package for importing data from Excel to my SQL server. The package, when ran manually from SSMS v17, works. However, when I attempt to do so via a Job within SQL Server Agent in SSMS v20, I get an error message that is the following:
However, I do have this driver installed, and with the correct bit version of it, as I am running 32bit SSMS and I did my correct install on it. I can import data to my SQL server when not running as a package in v20, and by manually launching the package in v17. but I cannot get it automated due to this.
How do I get past this issue?
Also, if more information is needed, this is how I'm set up:
- I use SSMS v20 (32bit) with my main account (which has full SQL access) and I'm trying to initiate the job from here via SQL Server Agent
- I have SSMS v17 (32bit) installed in order to view and access the Integration Services in this SQL Server (as it won't let me in future versions)
- I have downloaded and installed the 32bit driver at this link https://www.microsoft.com/en-us/download/details.aspx?id=54920&msockid=2be7d0b129366a522c1dc56e28b66b77
A written-out description of the error is below:
Description: The requested OLE DB provider Microsoft.ACE.OLEDB.16.0 is not registered. If the 32-bit driver is not installed, run the package in 64-bit mode. Error code: 0x00000000. An OLE DB record is available. Source: "Microsoft OLE DB Service Components"
And I have tried running the job in 32-bit mode, and 64-bit mode to make sure
SQL Server Integration Services
1 answer
Sort by: Most helpful
-
Erland Sommarskog 122K Reputation points MVP Volunteer Moderator
2025-07-08T12:29:11.3233333+00:00