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

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

To see the System Variables, there is a gray button for that. Also, you are only shown variables for the current scope. To see all variables in the package, click the blue “Show All Variables” button.

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