Dungeon Works: SSIS Log Simplifier

Here's a simple tool made on winforms that will help you simplify the log files generated by the execution of SSIS packages .

Analysis of the log file may take up large quantities of time,

ie. to find an error that occurred during the execution of the packages we use search function in notepad to traverse through the log file generated by the package execution.

This tool will help ease up the process by providing a parsed HTML file which is readable version of the log file, highlighting and grouping the errors and warnings thus making it easy to find the error quicker.

Read on to find out more

Steps:
1. Launch SSIS PILL .exe

2. Click on Get Files after

Selecting your folder that contains the SSIS log files
Click on Get Files - on the left side all files in the selected directory will be displayed
This will show the status of the file like success or failure and time taken
This is a pictorial indication that the file is a success
These are where warnings are displayed

3. On selection of file with error records

Now the picture is different for log files with ERRORS.
The first grid shows the ERRORS and the second the WARNINGS
This thing works full screen too

4. Click on Open In HTML for Parsed Log File, the parsed file will open in browser.
As you can see this is in a better readable format.

Has status of execution at the top
First grid is of ERRORS
Second Grid is of WARNINGS

5. Other buttons

Export to HTML will Create a directory in the same as your parent directory of your log folder and place the Parsed HTML files there.

Open in HTML will open the selected log file's parsed format like in step 4 in the browser

Open in Text - will open normally in a text editor