Are the N1–N7 column headings fixed or dynamic?

So ... declare it, or use literal text if it's always the same!
I did not give you my code it its entirety, you'll have to fill in a...

The double quotes method seems to work, while using single quotes does not, which is interesting.

DROP TABLE IF EXISTS #garbage;

CREATE TABLE #garbage
(
 ...

So is your package as simple as just a
truncate target
followed by a simple source/target dataflow?

Or does it contain any other transformations?

Can you post the results of running 'SCRIPT TABLE AS CREATE'  please?

Does your target table contain any indexes or keys (primary or foreign)?

Here is the DELETE version of the query posted above:

DROP TABLE IF EXISTS #seq;

CREATE TABLE #seq
(
  Primarykey INT NOT NULL PRIMARY KEY...

Could you try putting the Excel file onto one of the server's local drives and loading it from there? Just to rule out any possible network issues.

I agree...

Delete table
Where record <> 1
Looks like it would do it.

I can't see a single issue with what you are doing.
Have you tried setting breakpoints on the Foreach loop and the Output File tasks (select them and press F9)...