My EXCEL source in SSIS is exposing this error below on the server (local machine). Can someone please advise?
‘Microsoft.ACE.OLEDB.12.0’ provider is not registered on the local machine.
What I have tried:
When I tried with the same SSIS package on a client machine, no problem at all. Why is this NOT happening on the local machine?