SSIS: How to programmatically reference child packages?

Question

I have an SSIS package which in turn uses multiple child packages in it with execute package task. I am trying to run the parent package prorammatically using code similar to the following:

Application app = new Application();
Package package = app.LoadPackage(ConfigurationManager.AppSettings["PackagePath"], null);
DTSExecResult results = package.Execute();

But when I execute the package I get an exception saying "There is no project to reference". How do I reference the child packages?

Answer 1

Are you using a ReferenceType of "Project Reference" in your parent SSIS package? If so, change it to "External Reference", and provide the file path of the package, as shown in this question.