THE SQL Server Blog Spot on the Web

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

Davide Mauri

A place for my thoughts and experiences on SQL Server, Business Intelligence and .NET

DTLoggedExec 0.2.3.0 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.

EPD EPD2

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:

http://dtloggedexec.codeplex.com/

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

Enjoy! (and give feedback, thanks!)

PS

This 0.2.3.0 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.

PPS

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

Comments

 

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.

-Josh

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 (http://dtloggedexec.davidemauri.it/CSV%20Log%20Provider.ashx) 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

(required) 
(required) 
Submit

About Davide Mauri

Davide Mauri - MCP, MCAD, MCDBA, MCT, MVP on SQL Server - has worked with SQL Server since version 6.5, and his interests cover the whole platform, from the Relational Engine to Analysis Services, from architecture definition to performance tuning. He also has 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 solutions. Having worked as a Microsoft Certified Teacher for many years, Davide is able to pass all his knowledge to his co-workers, allowing his team to deliver high-quality solutions. He currently works as a Mentor for SolidQ and can be found speaking in many Italian and internationals events.

This Blog

Syndication

Powered by Community Server (Commercial Edition), by Telligent Systems
  Privacy Statement