Hi,

I have created a XML Configuration file for my SSIS packages configuration.
The DB connection string is stored in the configuration file.

The scenario is Main package calls the Child packages and the DB connection
is same for both the packages.

The package is executed fine without any error in the development
environment. On the other hand, while running my packages in Production
environment, the connection is established for Main package but when it
calls Child packages, connection cannot be established with DB.

Same error occurs when I try to execute the Main package using dtExec or
dtExecUI utilities in Production.

Any help in this regards will be highly appreciated.

Regards,
Stephen