SSIS Error while loading data from Excel
The requested OLE DB provider Microsoft.Jet.OLEDB.4.0 is not registered. If the 64-bit driver is not installed, run the package in 32-bit mode.
As said we need to run in 32bit mode.
While running locally using BIDS or SSDT make sure the project property Debugging => Run64BitRuntime is set to False.
In the SQL server 2012 job navigate to Configuration => Advanced and check the 32 bit run time option.