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...

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...

Looks like this was caused by an invalid certificate. No idea what was wrong with it but applying a newly-created certificate worked without issue.

Hi Jo.

HTTP works fine and I've configured all my reports, subscriptions, etc. without issue. It's only when trying to enable HTTPS that I hit a problem.

I've also attached a screenshot...

Just to verify this, how can I check the membership of the MSSQL$INSTANCENAME group? Can't...

Not that I'm aware of. I performed the install and selected the AD account to run the SQL Agent service which is currently the one in use.

Tim - There's an OnError event handler at the package level but that just does an INSERT into a log table