A White Paper By Mike Davis
SSIS is a fantastic Microsoft tool for performing Extract Transform and Loading (ETL) procedures. The challenge with SSIS, though, is identifying a problem once you deploy your packages to production. In his whitepaper, Mike discusses how to set up auditing and logging on SSIS packages to trap for problems and performance issues. He explains how to do this with native tasks built into Integration Services and how to audit SSIS using BI xPress.