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 years, 10 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...

You could create a database project in VS and then import the database structure into that. Doing so will create the individual files you need (though not with IF EXISTS...

Given your >13,000 points, I need to confirm with you whether this is a joke?

Actually  i want  to do  sum of qty in subitem_id 203 and 299 and subtract it form item_id 103 group by item_id.

OK, based on this description, try this

            
February 5, 2024 at 12:08 pm
            
#4373534

            
            
                                                
        

Nice try, but there are a few issues.

1. You have not included a CREATE TABLE, but I was able to get that from your proc definition a few posts earlier

...