Best way to implement Auditing - Logging Framework in SSIS for ETL Projects

Question

We have several SSIS packages and want to audit the follwoing items

Package runtime Errors, Warnings Extracted/Loaded Row count Source and destination Filename, SQL Query, table name Package and Task Performance

So far I found only one tool from Pargmaticworks BI xPress - Audit, Notify, Deploy SSIS

Anyone used this before... all features are very impressive and Reports are awesome

Answer 1

This book has a detailed chapter on setting auditing up in your SSIS packages:

http://www.kimballuniversity.com/html/booksMDWT.html

It is also available on safari books online.