Can you clarify the problem a little, please? Is it

a) Files are not processed in the correct order, or

b) Multiple files are processed at the same time (because multiple instances...

All of our solutions come crashing down if the start and end times span midnight, of course.

To import xlsx files (in both 2015 and 2017), you need to install the ACE drivers. Ideally, you should install both the 32- and 64-bit versions. This link will...

My version looks similar to the above!

DROP TABLE IF EXISTS #Time;

CREATE TABLE #Time (StartTime INT, EndTime INT);

INSERT #Time (StartTime, EndTime)
VALUES
(830, 1100)
,(1200, 1600)
,(0, 2359);

SELECT
    calcs.StartTime
,...

403 is an HTTP error. Perhaps HTTPS is now being enforced?

Your solution sounds more complicated than it needs to be, but well done on working out something usable.

May I suggest that in future you do as I suggested and provide...

It helps people if you format your code as a code sample. Here is your code again:

--V1:
WITH cte_filterdates
AS
 (SELECT TOP 1
      ...

1. You have stated your requirements, but not asked any questions. What do you want assistance with?

2. If you are hoping for coding assistance, please provide sample DDL, along with...

This syntax works ... not sure whether it gets you where you want to be.

DECLARE @TheDetails VARCHAR(MAX);

SET @TheDetails = 'The Following Items Have Changed: ';

IF 1 <>...

I don't know the answer, but if I were you, I would focus my initial attention on understanding this particular part of the error message:

The remote server returned an error: (412)...

• This reply was modified 4 years, 7 months ago by Phil Parkin. Reason: Fix typo

One thing I can think of is to set up an alert which detects 'long running jobs'. There are many ways of doing this, but one is to have another...

One additional thought.

You can future-proof the separate database idea to a large extent by using database schemas which are different from those in your existing database.

If you do this and...

OK, that's a good reason, thank you.

To be honest, I can see only a few pros of putting the new tables and structures into the same database as your current...

... creating new database and porting it's table structures ...

Why would you even consider this, when you have BACKUP/RESTORE as the obvious alternative?

Does this 'system' already have its own database? What is the reason for this migration and why are you considering throwing away the existing database?

As the data in the 'system'...