[quoted text, click to view]

Hi Feruis,

It sounds like you need to re-visit your package configurations and
security settings. If you haven't had much experience deploying SSIS
packages then parent/child package deployment can be quite a headache
(sometimes even if you have!) In my experience, the majority of
deployment issues are due to package configuration settings.

Have you taken a look at the Project Real case study (available on the
MSDN website)? It provides a pretty good overall look as SSIS's
functionality and highlights some of the issues that the Hitachi team
had to overcome. They also give some recommendations on how to
configure and deploy parent/child packages which you might find
useful.

It might also be a good idea to check whether the windows account that
SQL Agent is using to execute the package has the correct permissions.

Good Luck!
J