To me, as a professional software developer, SSIS is severely hindered by its lack of the ability to pass variables into a package. It is such an obvious and simple piece of functionality that it seems incredible to believe that, within SSIS as standard, a parent process cannot tell a child how to behave. This is almost akin to not being able to pass parameters into a function. After trying various methods (calling DTSRun , storing the variables in a table, etc.), none of which I was entirely happy with, I decided to resolve the issue myself.