Davide Mauri Blog

Experiences with SQL Server

SSIS Logging: DTLoggedExec news

I've been able to work a little on my DTLoggedExec project in this last week. You can find a log execution result here:

http://www.davidemauri.it/files/DTLoggedExec_test_output.txt

DTLoggedExec now supports some of the original DTExec options and is able to log even variables values, as you may see from the link above. DTLoggedExec will also support a plugin architecture so that creating a custom log provider will be as easy as 1-2-3. Currently developed log provider are:

  • NullLogProvider
  • SqlServerLogProvider
  • ConsoleLogProvider

The Null log provider will just trash every information it gets. I'm using it to benchmark the impact of other providers on package execution. SqlServerProvider will send all information to a sysdtslog902 table. Note that the table is NOT the original sysdtslog90, since DTLoggedExec can log A LOT more information than the orginala tool. The ConsoleLogProvider will just send data to the console. This is the log provider I used to create the test_output.txt file that I put on my website.

I've also a great news. I've decided to release the code under the Creative Commons license, and I'll release the project on CodePlex (I've just requested to open a new project for that) for the end of this month.

Of course any comments and feedback is appreciated!