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 ...

If you’re the creative type, you can run this task and write the data to a variable, which can be further queried by your SSIS package. With a little work, the Data Profiling Task tool is one that can ...