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.

I would not even try to figure out what is causing the issue - you are still on the first version of 2014 - upgrade that to the latest SP ...

convert to date
select max converted date

and fix your tables - dates should never  be stored as anything other than dates .

one other option is for the job that does the first snapshot to start the second job on the other server as the last step on the job.

My assumption, by reading the sql posted, is that the hash is done as part of the load of tbl_Staging_Current_SubjectXYZ.

so one of the approaches I was suggesting is