I have inherited an SSIS package that has over a dozen Execute Package Task controls in it. They are all contained in one "master" package and that package is executed from a SQL Server Agent job. My question is this - Is there any reason or benefit to running each of these packages from an Execute Package Task control in one package rather than creating a step in the current Agent job for each package?
One reason might be that there is some sort of execution logic built into the package - including running order, degree of parallelism and conditional execution.
Help us to help you. For better, quicker and more-focused answers to your questions, consider following the advice in this
If the answer to your question can be found with a brief Google search, please perform the search yourself, rather than expecting one of the SSC members to do it for you.
Please surround any code or links you post with the appropriate IFCode formatting tags. It helps readability a lot.