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?

After installing VS2022, go to Extensions and install the

SQL Server Integration Services Projects 2022

extension. That should get you going.

Because it's a CROSS JOIN, but I only want to subtract...

• This reply was modified 1 year, 8 months ago by Phil Parkin.

Well, if REPLACE(e.eligibility_ud,'-01','') is a very common operation in your system, you could create it as a PERSISTED COMPUTED column.

You could also see what happens if you replace that inner...