June 2006 Blog Posts
DTLoggedExec page online

I've created a dedicated page for my DTLoggedExec tool.

By the end of the month (June) i'll put online the full source code. The code and the application are licensed under Creative Commons Attribution-NonCommercial-NoDerivs 2.5 Italy License.

The "NoDerives" licensing limitation just means that if you want to contribute to the project you have to join codeplex and/or contact me so that I can add you to official authors list.

The "NonCommercial" licensing limitation just means that you cannot take the code and the executable and sell it. Of course, if you want to use it in your production eviroment, that's fine.

posted @ Wednesday, June 28, 2006 9:21 AM | Feedback (2)
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:

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!

posted @ Saturday, June 03, 2006 5:53 PM | Feedback (0)