Good article, thanks for sharing the idea, however I have a complex ETL where I am thinking of implementing this Audit but the problem is, Manually creating the Package/TaskID, Name pair and its child relationship in the table is not practical, since I have around 9 dataflow tasks with approx around 700+ tasks overall.

Secondly, the audit log table structure and where the insertion of log is happening can be explained little elaborate for the readers to understand the flow.

Please help on this, thanks:-P.

Regards

Basheer