I am using XML package configurations to manage changing variables between environments. One problem I have is that I have to run multiple instances of the package on the same computer with different configurations. Within BIDS, it requires a hard-coded path to the config file, as far as I see. To deploy this, I remove the package configuration and then use dtexec with the /CONFIGFILE parameter to pick up the config files.
This works, but it is tedious to remove the package configurations before releasing any packages. I have tested and if they are not removed, the internal hard-coded package config file overrides the command line one. Does anyone know if there is a way in BIDS to dynamically set the config file location? Thoughts I've had are making it run dtexec.exe with command line parameters, and using expressions, but I have not seen any way to do either.
Thanks in advance for any help,