A blend worked well for me at one shop where an environment variable pointed to an XML configuration file, and that XML configuration file contained a connection string for a Connection Manager that pointed to my [SSIS Configurations] table. From there the Package Configurations took over and everything was driven by the values in the table, which were obviously different between environments and could be modified via SQL scripts that were deployed into the database at the same time when the SSIS Packages were deployed.