Tom.Thomson (2/2/2011)

---

The next bit

Or you can alter the connection string to the configuration table. If you point the connection string of the config table to another config table, you can change the configurations from within the job.

is explicitly NOT possible, the relevant words in BoL are

You can use the /ConfigFile option to load additional configurations at run time that you did not specify at design time. However, you cannot use the /ConfigFile option to replace configured values that you also specified at design time.

This amazed me;-). Especially since those words follow other words that strongly suggest that you can override anything in the config. And even more so because specifying a config did what you would expect in SSIS 2005. MS have reduced flexibility here, and I think it's a silly backwards step.

Because the events occur in this order, you can dynamically redirect a configuration by using the /SET command-line option to change the configuration string.