Thanks for the feedback. On our new server (which is actually PowerBI) we have moved to DNS aliases so moving forward, we'll be fine. Just need to deal with the...

Ah. That's annoying. But thanks.

Is there a way to redirect SSRS given that I don't want to uninstall it just yet.

Sorry; phrased my question badly.

Since SSRS isn't running, *how* is it intercepting the URL? Why isn't this seen by IIS as any other HTTP request and redirected?

That's what I meant.

So I've been doing some more investigations into the issue, running ProcMon against the PowerShell process while the task was running and found that there was a 5 second pause...

Why do they need to see that information?  It could contain sensitive data (e.g. passwords) that should not be exposed - and really doesn't provide any additional information that...

I haven't tested this but maybe it requires one of the SSIS permission roles? I think this is the relevant documentation https://learn.microsoft.com/en-us/sql/integration-services/security/integration-services-roles-ssis-service?view=sql-server-ver15

As I said not tested and some of...

Hi Alex. I hadn't tried it but I just have without success 🙁

This may be a niche issue but the resolution (after logging with Microsoft) was as follows:

1. SPNs on reporting services service account had to be updated to HTTPS/... as opposed...

ERROR

Yes I am an administrator on the server and the disk is not compressed.

Further investigation with Process Monitor is pointing to whichever system process is creating the "Watson_1" folder at:

C:\Program...

Solved it! Typical, just after posting the question :-/

Need to remove "ORDER BY" from the COUNT(*) window function. Corrected line is:

    COUNT(*) OVER(PARTITION BY...

Found a workaround. The package has an "overall success" variable, which is just a combination of all the individual success variables. Consequently I'm now stepping through the Expression of this...

Thanks kaj; that did it.

Wasn't needed in "native" C# but clearly was in the Script Task.

Dts.Variables[string] is just an array where the string represents the variable's name. Iterating through an array should not be a big deal.

I have variables:

table1_Success, table2_Success, etc.

So all I want is...

Nice idea. However I use the result of the boolean variable in "Expression and constraint" connections so I'd still need that variable.

It seems strange that there isn't a way to...