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

Now, as an example, say you wanted to run a package that connects to a database; however, you may want to change the server name at run-time. First of all, we define a variable for the server name ...