If you know the absolute maximum number of rows in the source, you could perhaps add an NTILE to your source query & then have a conditional split which sends...

Ah, sorry, I should have read your post more closely.
At least it gave me the opportunity to create my first temporal table, so thanks for that!

I suspect that dd is a reserved word. Try using [dd] instead. I just tried this with no problem, and it's basically the same construct as yours:
SELECT

I can only imagine how annoying that this is. I'm running out of ideas, but I think I would do the following:

1) As well as scripting the close...

If your data is always in the very structured format your sample data shows, this works:

DROP TABLE IF EXISTS #Temp;

CREATE TABLE #Temp (Name NVARCHAR(200));

Not sure whether it is relevant, but what is the value of the RetainSameConnection property on the Excel Connection Manager?

Was the file copied, or moved? Copying should inherit permissions in the way you want, but moving does not necessarily do so.

Good to hear! Thank you for posting back.

OK, good. 
If you check both
C:\Program Files (x86)\Microsoft SQL Server\130\DTS\Binn
and
C:\Program Files\Microsoft SQL Server\130\DTS\Binn

Do the paths exist?
Do they contain any .bak files at all?