| Monitor your SSIS Package execution with PowerPivot |
| Written by Kasper de Jonge |
| Thursday, 17 December 2009 20:27 |
I had a interesting week so far, we had a problem in one of our reports, to debug this I wanted to gain insight in how well (or not) our SSIS packages where performing. Eventually the solution was a not in the SSIS execution but a Sproc not being deployed to the production environment (mea culpa  ).
I started by querying the SSIS logging table used by the SSIS logging provider to determine the execution time of packages and controls. Watching the bulk of data coming up (we run a few packages every minute) and some smart ordering I quickly decided package execution was excellent so the problem had to lie elsewhere. But while browsing through the data i got the idea wouldn’t it be great when we could see and analyze how package execution performs through the day, or per package, or per day of the week. What better way to do this than by PowerPivot? Read more... |
Author articles
- Help, I received a pivoted data file that I want to combine with my data in PowerPivot
- When Importing from Tabular Model use DAX
- Analyze a Twitter feed with Excel 2013, DataExplorer and GeoFlow
- NBA team spending and their results with Excel, PowerPivot and Data Explorer
- What is eating up my memory the PowerPivot / Excel edition
Most Popular
- Step by step guide on installing PowerPivot for SharePoint on a single machine
- How to install PowerPivot for Excel and list of know issues
- List of suggested datasets to test PowerPivot
- List of PowerPivot DAX functions with description
- Microsoft Virtual Lab: PowerPivot for Excel 2010 Introduction
- Learning PowerPivot and DAX
- List of PowerPivot DAX functions (short)
- PowerPivot's impact on BI pros?
