Earlier today I stumbled upon a blog post that I wrote back in 2008 entitled Absolute and relative paths where I said:
A common complaint about SSIS is that it does not allow the use of relative paths. The most useful application of this feature would be the ability to execute packages (using the Execute Package Task) where all the packages are (as is typical) stored in a single folder
I also pointed at a Connect submission I made requesting a solution to this problem which you can read at New [System::PackageLocation] variable please (54 votes and counting); someone at Microsoft replied in July 2010 with the following comment:
We believe that changes being made in an upcoming release will alleviate the concern you expressed; and therefore, we are closing this issue.
Fast forward 8 months to today and we now know that the change being spoken of is the ability to execute a package that is distributed in the same SSIS project (read more about this feature at The new Execute Package Task in SSIS in Denali). I'm in agreement with Microsoft - I think that this new feature does indeed solve this problem however I'm interested to know what other folks think. Do you have any scenarios in your current SSIS implementations that are not served by this new feature? Let me know in the comments.