Issue in running Sql agent job in 32 bit

SSIS and Import/Export
1

Hi,

We are used the /X86 to run the SSIS package in 32 bit from sql agent job. When we moved the same sql agent job script to microsoft sql server 2016, We are getting below error. When we manually run in microsoft sql server 2016 its working, but through the sql agent job its getting failed with the error.

Error: The requested OLE DB provider Microsoft.ACE.OLEDB.12.0 is not registered. If the 64-bit driver is not installed, run the package in 32-bit mode. Error code: 0x00000000.
An OLE DB record is available. Source: "Microsoft OLE DB Service Components" Hresult: 0x80040154 Description: "Class not registered".

Can you please let us know that /X86 is support in microsoft sql server 2016.

Thanks in advance.

2

That's not so much a SQL Server question as an Integration Services question. Actually it probably is a Windows Server problem (you're running on Windows Server 2012/16, right?)

In any case, a little googling turned up this article:

https://social.msdn.microsoft.com/Forums/en-US/1d5c04c7-157f-4955-a14b-41d912d50a64/how-to-fix-error-the-microsoftaceoledb120-provider-is-not-registered-on-the-local-machine?forum=vstsdb

Which is probably applicable

1 Like
3

You can explicitly run it 32 bit, it's a setting in the job step, or install the 64 bit ACE driver.