Nice article. I would go for extending an existing solution than re-inventing the wheel, which is - project real. ETL auditing is provided as code samples and well documented. Not exactly the perfect solution, but one can always extend on these solutions and make an SSIS template package and embed the custom auditing in that, so that any new package created will benefit from it.