Bhagat S
asked on
SSIS: stop package when condition is not met
My SSIS package needs to run on the last working day of the month, so I have created a lookup table that returns a row when the systemdate matches the calculated month end date which returns 1 row. When it is not month end, 0 row is returned.
With this I have created a variable (on success) to run the other packages.
However, I need suggestions on how to implement ending the execution without errors when the condition is not met (as the job will be scheduled to run daily).
See attachment for info.
Thank you
MonthEndFlag.png
With this I have created a variable (on success) to run the other packages.
However, I need suggestions on how to implement ending the execution without errors when the condition is not met (as the job will be scheduled to run daily).
See attachment for info.
Thank you
MonthEndFlag.png
With the existing configuration, You will not receive any error if it's not month end. You are good with constraint.
If you want, You can add an expression for disabling of the task in the expression section but for your scenario. It's not needed.
Thanks,
If you want, You can add an expression for disabling of the task in the expression section but for your scenario. It's not needed.
Thanks,
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
and updated Precedence Constraint expression to > 0 which seems to work