We have a "Execute SSIS Package" task that executes daily and uses yesterday's date for a portion of the import. We created an entry for the variable and wrote an expression to get yesterday's date[1] as the value of the variable, but what we noticed is that every time the task executes, the server saves the evaluated date of the run and uses that for all subsequent runs rather than reevaluating the expression for each run.
Is there any way to set an expression as the value variable that would be evaluated at the time of the SSIS run?
[1]-
{DATENOWADD(Days|-1|MM/dd/yyyy)}