Might be a bit to powerful for what you need but check out dSeries workload automation from Broadcom, used that in the past for this type of centralised job...

Thanks for responding. I'm hoping to find something a bit prettier than SQL Agent, and ideally a product which is independent of SQL Server, as it may be used for...

Note to self: remember to rent a Lambo one day.

I haven't had this, as far...

I first added an 'Expression task' to the Control flow but then nothing was passed to the Source Editor query window...I wonder why? What is it for then...

The Expression Task allows...

I've been having lots of days like that recently. Then again, I am working with Azure Data Factory.

I don't think you can control the format of Agent history messages. But maybe you could write any errors to a table and then query that.

Have you checked the All Executions report?

I suspect that the tasks are not being skipped, rather that they are not executing successfully, which would be in line with TangoVictor's post...

Wouldn't it make more sense...

First step is to create a variable to hold Value_Date. Despite the underlying datatype being (presumably) a date, you may find it easier to work with strings within SSIS expressions.

Then...

I do know one way to address this is to create a variable and populate it with the result of this calculation and pass that variable as a parameter

As far...

Thank you. I'll have to add the unique constraint. I would remove the composite key, but in this case I'm a bit more wary as it might affect their...

Adding in a UNIQUE constraint makes this work. Without it, SQL does not know that it is unique, despite the IDENTITY property.

DROP TABLE IF EXISTS dbo.REPORTS_GROUPS_MAP;
DROP TABLE...

Great, problem solved.

So if you select File/New Project and then type 'SSIS' in the search bar, what do you see?