Lynn Pettis (8/1/2014)
You could also use a system variable to contain the same information regarding the location of configuration files. We went with the XML file as it was easier to maintain and allowed us to expand locations depending on information in the package as well. IIRC when using a system variable you can only point to one location. You would have to verify that to be sure.
This is correct. We use that in our environments as we use a dedicated SSIS Server with the configuration table on that. You can, however, have multiple system variables setup and have the configuarions link differently. I don't use XML configs however, but I know I've setup multiple data sources for the configurations via 3 different environmental variables, then had the rest of the configs read from different sources based on which data source they inherit from.
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA