How to use SSIS Log Analyzer tool ? (Video)

Leave a comment (2) Go to comments

While Optimizing SSIS packages, analyzing package log is really a pain as these log files are flat files and long so I lost focuses while reviewing.

I was looking for a smart tool to analyze the my SSIS logs and figured out this utility (SSIS Log Analyzer) , which is freely available at Microsoft.

This utility helps in analyzing SSIS logs and if possible provide cause and resolutions for issues found in it. SSIS Log Analyzer also provide 

  • 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.

Quick Video tour to understand, how to use SSIS Log Analyzer utility.


This SSIS Log Analyzer can be downloaded freely from http://ssisloganalyzer.codeplex.com/

EOF - How to use SSIS Log Analyzer tool ? (Video), SQL Server 2012 , 2008 R2 , 2008 , 2005 , 2000
Leave a comment

2 Comments.

  1. Hi,

    Were you able to open the log and package? i’m using SSIS on SQL 2008 r2 and the program runs into problems when it tries to open any package i have created – even the most simple/default of ones.

Leave a Reply

Your email address will not be published. Required fields are marked *


*


You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>

Notify me of followup comments via e-mail. You can also subscribe without commenting.