I have some confusion on testing the parent /child package in Visual studio.. I tried to set the execute out of process to true.. but it looks like when I am running it is not picking up any of my changes in the child package. So, I want to go back to basics.. I have a parent package and I create a new package. How do I select the new package as my child? It was not in my dropdownlist when I selected the connection for the execut package task.. that is one question and the other is how to test in visual studio - I had worked on this a long time ago and I thought I had to deploy the package to test it accurately versus testing it through VS. so I want to start over with a new project and work on testing this package locally first. any good links/tips would be appreciated. this is a follow up from my previous post as my error was in the file path that I removed and yet it keeps coming back and I think it is looking elsewhere when I run my parent package and not the one that I modified in VS. Thanks

Hello, Lets say you have parent package Pkg_Parent.dtsx and other pacakge Pkg_Child.dtsx. Both of the package you have can be in same Projects or even in different projects or even your child package is somewhere in disk without projects file etc. 1--Open your parent package(Pkg_Parents.dtsx) in BIDS 2--Drag Execute Package Task in Control Flow. 3--Configure Execute Package Task... click on package on left Side, then select File System in location and in Connection Brow to your child package and it will create connection manager to your package in connection manager pane. You are done. Execute your parent package. When your parent package will reach to Execute SQL task , it will open your child package in separate tab and execute it and then come back to execute next tasks in parent package. Please let us know your findings. Thanks http://sqlage.blogspot.com/

Thanks - that was it. I had completely forgot about that File location property!