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

Plan not attached. -- saw it now.

The main performance improvement on this type of process is using the hash compare as you do.

Following are possibilities -...

then as per the error the file can't be opened - pretty clear - and just proves that you didn't really search for anything - just expect that we do...

not enough really - just on the forums here you get 99 hits
and please post the full error message, not just a screen print that does not show the...

have you even bothered googling for it? first hit I get has the reason for the issue and the solution.

also take in consideration that having compression turned on (page or row, or even columnstore) will change the space requirements. many times significantly, specially with columnstore.

Add to this that Installing Excel on a Server is not supported by Microsoft and you would also have issues with licensing in that anyone accessing that server would require...

i do not think there is any other option than a third party tool for that.
see https://dbmstools.com/version-control-tools/sqlserver for some options for SSMS.

Most of the times and if...