one other possible issue - if the instances were running under his ID, any backup location may also require permissions to be changed. 
This both for doing backups and to...

you are most likely missing the ACE driver on your server.
you can check these if you have sysadmin access to your instance executing exec sp_MSset_oledb_prop
the output will list...

Sorry again - just to clarify.

Is the issue doing a select on a SQL Server instance to retrieve data from a Oracle db?

or is it Oracle...

I consider the following construct a bit simpler and does not require the temp table
and output gets ordered by column_id as required
code based on the OP. Does have...

Answer removed due to inappropriate reply from the OP

Disabling AV should not be required - but what needs to be done is to add some exceptions to the scan engine to ignore SQL Server related files (normally .mdf,...

bids/ssdt/visual studio is always 32 bit.

when I said you had to install the 32 bit version I meant the 32 bit version of the Access Runtime

no need for DSN.
Using SSIS, add a OLEDB or a ADO.NET connection. point it to your access file, and set other properties on it as required. 

As with...

you need Microsoft Access Runtime (ACE) 
https://www.microsoft.com/en-ie/download/details.aspx?id=13255
https://www.microsoft.com/en-us/download/details.aspx?id=26602 -- sp1

This will also help you https://www.connectionstrings.com/