title: SSIS 2008R2 Disable property stored back at design time from run time
body: <p>I've got a package where most of the activities run every day, but some only run on specific working days (mostly WD1). I have a variable that indicates the WD index within the month (e.g. 2 Jan 2019 is WD1 as the 1st was a bank holiday in the UK). I've set an expression on an Execute SQL task such that the Disable property is evaluated by (@WDindex != 1), i.e. it gets disabled when WDindex is anything other than 1.</p>
  
  <p>In BIDS, I enable all the tasks and run the package, let it run through and it behaves correctly. Once it is executed and I click the stop button, I find that the tasks that wouldn't have run today are still disabled. i.e. the Disable value passes back from runtime to design time values. They were enabled before running.</p>
  
  <p>So I have a few questions:</p>
  
  <ol>
  <li>Is this an obscure bug, or is it designed like this?</li>
  <li>If a container/task is disabled, with an expression on its disable property, will it run the expression to work out whether to re-enable it?</li>
  <li>Once on the SSIS server, does this behaviour continue? i.e. after running, is the value of the Disable flag stored back into the stored package?</li>
  </ol>
  
  <p>Obviously, I want the Disable property of the tasks to re-evaluate every time the package runs.</p>
  
  <p>Thanks for any help,</p>
  
  <p>Mark</p>