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 or somewhere in the file system ...
Businesses often have to move data around the way construction companies move dirt. A tool like SSIS, designed to transfer and transform large amounts of data, helps take care of the heavy lifting.