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.