Instrumenting, Monitoring and Auditing of SSIS ETL Solutions

Have you ever been struck by the lack of detailed logging available within SQL Server Integration Services (SSIS) packages?

If the answer to this question is yes, then you are probably a seasoned Business Intelligence solutions builder. The packages that make up your solutions probably contain extra code to facilitate effective monitoring, control and profileing. However, increasingly, SSIS is being used to unify data found on disparate yet related transactional systems. The batch processes that perform this activity thus become a vital part of the information processing ecosystem. These need to be monitored and profiled in the same way as formal BI solutions but often the resources available are much more meager. What do you do when something goes wrong and the functionality of the packages is not transparent via internal state reporting.

This session will introduce you to an improved version of DTExec. By passing the appropriate state flags it can reveal the internal activity of packages without having to make any changes to the packages themselves.

Davide Mauri

Davide Mauri - MCP, MCAD, MCDBA, MCT, MVP on SQL Server - works with SQL Server since version 6.5, and his interest cover the whole platform, from the Relational Engine to Analysis Services, from architecture definition to performance tuning.
He also have a strong knowledge of XML, .NET and the Object Oriented Design principles, which allows him to have the correct vision and experience to handle development of complex business intelligence solution. His latest work on BI is the creation of the entire BI solution for Deborah Group, so if your wifes and girlfriends are now spending more money on lipsticks, perfumes, and so no, please don't blame him.
Beside consultancy he loves to teach custom-made courses on the SQL Server platform. He actually works as a Mentor for Solid Quality Mentors and can be found speaking in many Italian and internationals events.

Davide Mauri's blog http://weblogs.sqlteam.com/dmauri/

---

Downloads

File Type Ext ContentName Presentation .pptx Slide Deck Zip File .zip Samples and Slide Deck

<< 1 >>

---

Other sessions from this conference

AddIns for SSMS - build your own

Comparing Azure storage and SQL Data Services

Data Mining and SSIS - makes sense.

Data Warehouse Data Modelling

Data Warehousing features in SQL 2008

Database Maintenance Optimization

Designing Effective Aggregations in Analysis Services 2008

Effective test-driven database development

End to End Report Creation and Management in SQL Server Reporting Services 2008

High Availability in SQL Server 2008

Implementing Clustering using SQL Server

Making the SQL developer one of the family with Visual Studio Team System

Message in a bottle: Service Broker from 1 to 100 in 75 minutes!

NHibernate – Open Source Object Relational Mapping (ORM)

Performance Optimization with SQL Server 2008

Performance Tuning your TSQL

Securing and Hardening a SQL Server Implementation - Notes from the Field

SQL Server Architecture: The life of a query

SQL Server’s storage engine

SSIS by example

SSIS Nuggets Live

Stop throwing hardware at the problem !

Understanding ADO.NET Data Services

Understanding Graphical Execution Plans

Universal calculated measures in MDX queries

Upgrading To SQL Server 2005 & 2008: Notes & Best Practices

What’s New in SQL Server 2008 T-SQL