• Thanks for posting back. As far as I know the validation errors you are seeing are considered non-fatal so SQL Agent carries on as usual. In your package you can set DelayValidation to True at the package level, or at the Container level as close to the Task where your Expression resides, to avoid any failures in BIDS.

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato