It definitely sounds like a permission problem then. My guess is that you're execute the package in the SSIS Catalog via T-SQL (you didn't answer this question), and your Kerboros...

I might be missing something here, but masterContacts.[Mailing Address Line 1] contains no records that have the value N'North Middlesex University Hospital NHS Trust'. Your where clause is filtering on...

Would you mind pasting a link to where to data is located to on gov.uk (don't provide a link direct to the source, but the page which contains the download...

Looks to be due to the "/" in the name is causing the rewrite rule to fail. 🙁

There will likely be more errors than just the one above. Check your Report Logs for an execution and copy all the errors out. Normally SSIS has a tendency to...

If the problem is still occurring, can you post the error you get?

Although this works in your example, what is a "column" is blank. Does the file contain a blank line, or does it go straight column? Just want to make sure...

I never understand numbers that have multiple periods in...

Running IE as local administrator won't make any difference. You need to use a network account that has administrative privileges

That's because you're logged in as the user who has denied access. You can't changed a user's permissions, when that user has denied access.

Access the web address from an account...

Oh no, of course not... They sit on my desk!

Wait,...

For lack of better words, clearly your team did not give the user sufficient rights to access the report, regardless of what they might say.

Ensure that the user has access...

If you're deploying to multiple environments, why not "parameterise" the connection string? Then you can simply pass the appropriate connection string parameter for the environment you are on.

Looking at your two examples, can I assume that the date at the end is always in yyyy_MM_dd_HH:mm:ss format? If so, this would work:

Create table #examples (string varchar(100));

Insert into #examples...

One thing you weren't really specific on is if a user has a email in column 1, and then appears in their (or someelse's) email 2. I've gone with if...