SSIS 2008. One parent, many child packages. All the packages connect to two SQL Server 2008 R2 servers. What I want to achieve is one configuration containing the connection details for the two SQL Server (server, database, username, password). So all the packages (parent and children) can use this configuration.
One way I can think of is to set variables for connection details in the parent and all children. And in the children set the variables to use the values from the parent. So I have only one place to set the connection details, which is the parent. But I will need to create variable for every child. I have a dozen of children, so that's a lot of typing and setting up.
So is there a better way to do this?