SSIS：优先级约束未按预期工作
参考下面的快照，我尝试使用“逻辑与所有约束必须评估为真”。在表达式中，我试图将变量值与当前日期相等，并且在评估表达式上检查它时，当条件匹配时它显示 true，但在运行包时它仍然不会移动到下一步。
使用的表达方式：
@[User::LastUpdated] == (DT_DBDATE) GETDATE()
请帮忙解决这个问题。谢谢。
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.
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（1）
第二个屏幕截图显示脚本任务已成功执行，这意味着满足第一个约束。您应确保
@[User::LastUpdated]日期值等于(DT_DBDATE)GETDATE()。提示：确保
@[User::LastUpdated]日期值不包含时间部分。您可以使用以下表达式来避免时间部分问题：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: