This utility helps in analyzing SSIS logs and if possible provide cause and resolutions for issues found in it.Features
Option to analyze the logs manually by applying row and column filters over the log data or by using queries to specify more complex criterions.
Automated Performance Analysis which provides a quick graphical look on which tasks spent most time during package execution.
Rerun (debug) the entire sequence of events which happened during package execution showing the flow of control in graphical form, changes in runtime values for each task like execution duration etc .
Support for Auto Analyzers to automatically find out issues and provide suggestions for problems which can be figured out with the help of SSIS logs and/or package.
Option to analyze just log file or log and package together.
Provides a lightweight environment to have a quick look at the package. Opening it in BIDS takes some time as being an authoring environment it does all sorts of validations resulting in some delay.
There are seperate builds for SSIS 2005 and 2008.
Currently just a sample Autoanalyzer assembly is included. Some rich analyzer assemblies will be uploaded later which can be added to the already installed version of this tool.Requirements
.NET Framework 3.5 SP1.
SSIS 2005 or 2008 (depending upon the package version being analyzed)Supported Operating Systems
Window 7, XP, 2003, Vista, 2008Screenshots
For a demonstration of the SSIS Log Analyzer, see the SSIS Log Analyzer (SQL Server Video)