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/

powershell is like any other windows command line tool 
a simple .ps1 script with the following will do the copy
copy source destination
or
copy-item source destination
or
robocopy source...

Adding a bit to this - first the annoying bit. this has been posted on at least 4 sites. 
This can lead some of those that know a possible answer...

This is a lot more complex than what you think.
Look at one approach https://www.youtube.com/watch?v=JJryD2dXVVw- does have issues that I am not sure have been solved in the meantime.