'SSIS: Precedence Constraint not working as expected
Referring to the below snapshot, I am trying to use "Logical AND All constraint must be evaluated to true". In Expression, I am trying to equate Variable value with the current date and when checking it on evaluation expression it shows true when the condition is matching but still while running the package it doesn't move to the next step.
Expression used:
@[User::LastUpdated] == (DT_DBDATE) GETDATE()
Please help on this issue. Thanks.
Solution 1:[1]
The second screenshot shows that the Script Task is executed successfully which means that the first constraint is met. You should make sure that the @[User::LastUpdated] date value is equal to (DT_DBDATE)GETDATE().
Hint: Make sure that the @[User::LastUpdated] date value does not include the time part. You can use the following expression to avoid the time part problem:
(DT_DBDATE)@[User::LastUpdated] == (DT_DBDATE)GETDATE()
Sources
This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.
Source: Stack Overflow
| Solution | Source |
|---|---|
| Solution 1 | Hadi |