Single Configuration file across multiple packages in ssis 2008

Question

Hi,

I have a solution with multiple packages in it. I want to create a single package configuration file across multiple  packages. Each packages has same connection string and different variables. I go through the some blocks but not resolved my problem, It says create config file in one package and reuse it in another packages.But each package has different variables , How can use those variable values in config file if i reuse existing file.

 Anybody Please explain me with step by step.

Thanks in advance,

Visu

Answer 1

Hi,

this is not possible i guess. you have to create same variables in all packages (even if you don't use them). Or create config file for every packages (which is not helpful).

Or you can use config table in SQL server where you can use filter.

for Example filter ALL for configuration which is applyed to all packages and one filter for package scope parameter with filter named after package. In result there will be 2 configuration settings for every package.

Zdenek

Answer 2

You can only reuse a config if all the items that are configured are available in the package. What you could do is create one config for the connection managers (you said they are all the same in each package) and create various configs for the variables.

Or (if it's only about a 1 or 2 variables) create all variables in all packages... but that could be messy or obscure for others that are going to work with that package later on.

---

Please mark the post as answered if it answers your question | My SSIS Blog: http://microsoft-ssis.blogspot.com | Twitter