Execute SSIS Package Variables Becomes Static After First Run - VisualCron - Forum

Community forum

tomlee
2011-12-30T17:40:16Z
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)}
Support
2012-01-02T08:55:37Z
This is a bug which will be fixed for next version. It is probably be posted in the beta forum soon. Thanks for the report.
Henrik
Support
http://www.visualcron.com 
Please like  VisualCron on facebook!
Scroll to Top