SSIS Event Log Business Intelligence

  •        63

The SSIS Event Log Business Intelligence package is a complete BI project focused around SSIS Event Log data. Components include: - 9 SSRS Reports - ETL Data Mart - SSIS packages to load ETL Data Mart - Analysis Services Cube - PerformancePoint Dashboard

http://ssisbi.codeplex.com/

Tags
Implementation
License
Platform

   




Related Projects

SSIS Event Log Source


An SSIS 2005 Data Source component for loading Windows 2003/XP event logs (*.evt) into SQL Server 2005 for analysis

IIS Log reader


IIS Log reader library is reading the IIS log data into intuitive domain model. Useful in ETL/SSIS applications. Intuitive, simple API.

SSIS Log Analyzer


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

Useful SharePoint Site Workflow Utilities


This project aims to make it easy use SharePoint 2010's Site Workflows as "event handlers" for various back end systems by providing ways to start site workflows on remote farms from SSIS, SQL CLR and any Soap Web Service Client.

Invoke-Phant0m - Windows Event Log Killer


This script walks thread stacks of Event Log Service process (spesific svchost.exe) and identify Event Log Threads to kill Event Log Service Threads. So the system will not be able to collect logs and at the same time the Event Log Service will appear to be running. I have made this script for two reasons. First, This script will help to Red Teams and Penetration Testers. Second, I want to learn Powershell and Low-Level things on Powershell for cyber security field.


Windows Event Log Manager


Windows Event Log Manager is a tool for creating, editing, and viewing windows event logs.

Event Log Analyzer


Event Log Analyzer is a simple yet powerful tool to analyze event logs in Windows. It has features to group similar events together, give graphical view of distribution of events over time and in similarity. It is developed in C# and WPF and uses MVVM framework.

eventsourced - A library for building reliable, scalable and distributed event-sourced applications in Scala


In other words, Eventsourced implements a write-ahead log (WAL) that is used to keep track of messages an actor receives and to recover its state by replaying logged messages. Appending messages to a log instead of persisting actor state directly allows for actor state persistence at very high transaction rates and supports efficient replication. In contrast to other WAL-based systems, Eventsourced usually keeps the whole message history in the log and makes usage of state snapshots optional. Logged messages represent intended changes to an actor's state. Logging changes instead of updating current state is one of the core concept of event sourcing. Eventsourced can be used to implement event sourcing concepts but it is not limited to that. More details about Eventsourced and its relation to event sourcing can be found at How does Eventsourced persist actor state and how is this related to event sourcing.

SSIS Twitter Suite


The SSIS Twitter Suite contains custom SSIS objects that call the Twitter REST API. All classes are in VB.NET. This project allows you to use Twitter in your SSIS package or as a template to create your own custom objects with different functionality!

PowerShell Script Task for SSIS


To produce a control flow task for SSIS that can be used to run PowerShell scripts within SSIS. It should integrate SSIS and PowerShell so that SSIS specific information (i,e. variables) can be accessed etc from within your script. The initial versionn has the following feat...

SCRUBS: SQL Reporting Services audit, log, management & optimization analysis


SCRUBS your SQL Reporting Services Logs to provide management, auditing & optimization reporting. SSRS provides robust logging in the Execution Log, but no management metrics in the box. You'd have to develop your own DW, SSIS procedures and metrics for reporting. Not anymore!

Dynamic Data System - ETL for SQL Server using dynamic SSIS


DDS makes loading a data warehouse much easier and faster. This system uses SSIS to load standard and partitioned tables via SSIS packages created on the fly using metadata. No longer will you have to maintain complex SSIS packages. Only basic T-SQL skills are needed. Pr...

SSIS Expression Editor & Tester


An expression editing and testing tool for SQL Server Integration Services (SSIS). It also offers a reusable editor control for custom tasks or other utilities.

ETL Framework


This ETL Framework supports dynamic configurations and centralized logging for SSIS solutions in support of minimizing ETL TCO. It consists of an ETL Framework database, SSRS reports and template SSIS packages.

SSIS - Oracle Destination via ODP.Net (Custom Destination Component)


SSIS 2008 R2 solution (custom destination component) to write to oracle via ODP.Net

SSIS Reporting Pack


* SSRS reports that operate over the SSIS catalog * A stored proc, sp_ssiscatalog, that provides detailed analysis of the SSIS Catalog

GDAL SSIS


GDAL SSIS is a collection of geospatial components for SQL Server Integration Services (SSIS) that leverages GDAL to support a large number of GIS data formats.

TaskUnZip for SSIS


Simple Task for SSIS (SQL Server Integration Services) for manage compress file ZIP. This task (Control Flow Items), permit compress/decompress file zip in SSIS Task context. Support password. _Work in Progress!_ ;-) Tnx to: *[url:http://sharpdevelop.net/OpenSource/SharpZi...

LogTrail - Log Viewer plugin for Kibana


LogTrail is a plugin for Kibana to view, analyze, search and tail log events from multiple hosts in realtime with devops friendly interface inspired by Papertrail.