I am quite new to SSIS, and I've run into a problem deploying a set of packages on SQL Server 2008 R2.
I developed a set of packages for loading data from a source system in a SLQ Server,
I have a master package that coordinates the execution of a set of child packages.
The packages are configured using a set of common XML files, DEV, QA, and PROD run fine.
I scheduled the loading using SQL Agent with the packages on the file system, all runs through without problems.
Now I would like to have all my packages store inside msdb instead of file system.
I deployed my packages to msdb, and reset the agent to run the master in the msdb,
but at runtime the master package looks for the child packages on the file system not in the msdb.
What should I do to deploy everything so that the master uses the child packages in the msdb?