To Jeff Moden point, I will discuss how to obtain package information for cases where people may have a lot of Packages. The reason I wanted to discuss the approach I employ separately is because I use the SSIS object model and C# which in itself require some explanations, I just did not want to take the focus away from what I was trying to achieve with this series.

Kevin to your concern:

In this article "Serving Warm SSIS Errors" on SQL Server Central you can check out the “Enabling SSIS logging with SQL Server log Provider” section for details on how to setup the suggested logging mode. After you’ve enabled logging it does not matter where you deploy your packages. As for the Package ID tables as you see later all you need to be able to join the it to the SSIS logging table into which you enabled your logging.