I am having a package which has one execute sql task, for each loop enumerator and inside for each enumerator I have a execute package task.In the execute package task I have a child package which has a variable that I need to pass to parent package. How should I do that?. Any help is much appreciated.
dts enables you to pass variable from parent package into child package. Take a look into http://www.sqlshare.com/SSISVariablesinParentChildPackagesandJobs_809.aspx
The opposite, child to parent, that will have much work to do, but we can figure out one way to do it. Let me know what you really need.
See this blog post: