I hope I understand your question..

I use Execute Package Task in Control flow to execute the SSIS package..

Basically I have one PARENT Pkg that calls pkgs using "Execute Pkg Task"...

No I dont know any web site or any article...

We did it by trying again and again...

To answer your question... I dont think you need multiple files for multiple connection...

I...

Well.. The answer is same Variables....

I have defined the path of my packages in a variable...

My packages also need FLAT File loads and while development the path can be a...

I am using Variables and it works fine...

All you need to do is define Variable at pkg level.... say db1_connection

and on the Connection Manager for that connection use expression

It...

I read somewhere (dont remember that it was BOL or some other blog) that XML Config has one issue that it wants that all the CONNECTIONS that are in XML...

I am using single XML config...