CODEWITHSUNDEEP
visual-studio-2015ssissql-server-data-tools
Al__H
Al__H

Reputation: 306

SSIS Constraints

We have containers(steps) which only run on Wednesdays. I want SSIS/VS to wait until that has been evaluated before proceeding. Please see this picture for an example: Example SSIS Package

In the example, Pass_3 only runs on Wednesdays. I want Pass_Final to wait, until Pass_3 is evaluated and either runs with Success or doesn't run. If either of those occur, go to Pass_Final. But, if Pass_3 runs and fails, don't proceed to Pass_Final. The way it is currently, if Pass_3 doesn't run, Pass_Final will not run.

Is this possible? Visual Studio 2015/SSDT 2015

Upvotes: 1

Views: 47

Answers (1)

Tab Alleman
Tab Alleman

Reputation: 31775

This would be easier to follow, I'm sure, if I provided an image, but right now I only have time to type. Hopefully this will be clear enough.

What you need to do is to re-work the pass_3 path so that it returns true when it's not Wednesday.

One way to do that is to add a dummy script task that doesn't do anything between pass_3 and pass_final. So you will have completion constraints going from pass_3 to dummy_task and also from dummy_task to pass_final.

THEN you add a constraint from pass_1 straight to dummy_task that checks to see if the day is NOT Wednesday. And use an OR condition on the constraints going to dummy_task so that only one of them has to be true.

What this does is, on Wednesday, pass_3 will be used, and when completed, it will activate dummy_task which will pass through to pass_final, and every other day, pass_3 will be skipped, but dummy_task will still get activated and pass through to pass_final.

hope this is clear enough.

Upvotes: 2

Related Questions