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

You'll wonder no more how to manipulate SSIS Package Variables via Script Tasks, once you're done reading this little tidbit. While not a difficult task, the question of how to manipulate SSIS package ...