Koen (da-zero) (2/2/2011)
Carlo Romagnano (2/2/2011)
Koen (da-zero) (2/2/2011)
paul s-306273 (2/2/2011)
So, is the correct answer 'FALSE'?No, it is TRUE.
You cannot use the /Set or the /Connection option to override single values that are also set by a configuration.
OK, What is the use of /Set or the /Connection option? :w00t:
Override values that are not set by a configuration 😀
And that's all:exclamation: 🙁
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.
Tom