THE SQL Server Blog Spot on the Web

Welcome to - The SQL Server blog spot on the web Sign in | |
in Search

Davide Mauri

A place for my thoughts and experiences the Microsoft Data Platform

DTLoggedExec beta published!

Finally today I found the time to publish the latest release of my DTLoggedExec tool. This is quite big release, since I have introduced two new events, LogStartPackageLoading and LogEndPackageLoading, that allows a Log Provider to intercept event related to package loading and not package execution. This is really helpful to debug those situation where package doesn’t even gets started because some error during loading happens.

This addition also allows me to produce much more precise reporting. And this is the other big thing of this release. Available as separate download you’ll also find some ready-to-be-used reports that consumes all the data you can gather using DataFlow profiling and CSV Log provider. They are just samples of what you can do, but they can also be useful even as they are, without any modifications. Of course I encourage you to change them to suit your need.

Reports needs Reporting Services 2008.


I’ve tested execution times having DataFlow profiling and CSV Logging for Error, Information, PreExecute and PostExecute events and I can say that you won’t have *any* performance impact.

So, as usual, if you’re into SSIS, don’t miss this new release:

I can tell you that this tool will make your SSIS-related life much more easier!

Enjoy! (and give feedback, thanks!)


This is quite surely the latest beta version. The tool is really stable so for the next version I plan to clean up a little bit the code, update the command line parser and then finally remove the “beta” statement.


Due to some problems related with Codeplex SVN service, I wasn’t able to update also the source code…I’ll do it as soon as the service will be available again.

November 30th - SVN Problems solved and source code updated. :)

Published Saturday, November 28, 2009 10:21 PM by Davide Mauri

Comment Notification

If you would like to receive an email when updates are made to this post, please register here

Subscribe to this post's comments using RSS



Josh Robinson said:

Davide - I sat in your session at SQL PASS and I have been checking daily to see when you were going to update the release with the reports.  Great news that you have added other things as well.  Thanks for all the hard work, we are going to move all of our production loads to DTSLoggedExec and remove existing SSIS logging + custom events for auditing that we have now.


November 30, 2009 3:24 PM

Paul said:

Davide great product. Please advise though how i get the logging results stored in the DB? I have set up the product as advised but don't know what switch to use to get the logging to be persisted to the database

March 3, 2010 6:32 AM

Davide Mauri said:

Hi Paul

there is no DTLoggedExec native log provider that logs directly into a DB sinc it will hurt performance too much.

You just have to use the CSVLogProvider ( and the load the logged data into the DTLoggedExecDB database using the provided scripts. (import-log-data.sql)

March 7, 2010 3:42 PM

Leave a Comment


About Davide Mauri

Director of Software Development & Cloud Infrastructure @ Sensoria, an innovative smart garments and wearable company. After more than 15 year playing with the Microsoft Data Platform, with a specific focus on High Performance databases, Business Intelligence, Data Science and Data Architectures, he's now applying all his skills to IoT, defining architectures to crunch numbers, create nice user experiences and provide meaningful insights, all leveraging Microsoft Azure cloud. MVP on Data Platform since 2006 he has a very strong background development and love both the ER model and OO principles. He is also a fan of Agile Methodology and Automation, which he tries to apply everywhere he can, to make sure that "people think, machines do".

This Blog


Privacy Statement