Calling an SSIS package from another SSIS package is, on the surface, a simple task. You just use the Execute Package Task and point it to a package on a SQL Server ...

You can design your SSIS packages in various ways, but you should always keep your goals and other factors in mind The other night, I gave a presentation on SSIS architecture to a local user group, ...