• We run dozens of SSIS jobs daily. I use the [SSIS Configurations] table to store all of our package configs. This works well for us. Everything is in one place and it is easy to update. Also we use a specific naming convention with our package variables across all of the packages. For instance we have a standard variable called BFP1 which contains the "base file path" or root folder to which many of our SSIS data extracts are written. Should we ever decide to move that location, it is as easy as a simple update query where the variable name = BFP1 and all affected packages will be updated.