DTLoggedExec 0.2.1.4 Beta Description:

The DTLoggedExec was desiged to a tool that allows you to run a Sql Server Integration Services (SSIS) Package producing a full and detailed logging informations of execution status and package runtime data, including dataflow profiling information. In brief it allows to fully log and instrument package execution.

If you're using Sql Server 2005/2008 Integration Services, you should know that the packages you've created can be launched via DTExec or SQL Server Agent. In both cases you'll find that, though an extensive logging infrastucture seems to be present, logged information doesn't really help you to understand why and how a package that has always run correctly someday decides to go wrong.

In addition to this big limitation you may also have already discovered that logging can't just be switch on or off right from the execution tool. Though it seems possibile, if you want to log on a text file your package MUST contain a connection manager that points to the file you want, otherwise logging cannot be used. This means that you should engineer your packages so that they support the logging infrastructure, BEFORE you need it. This also means that you have to take care of preparing the way for logging in ALL of your packages.

This is really not how logging should work for me. I need something that can be switched on or off as I desire, without having me to do anything during package development; in addition I need ALL the data and the information I can have, since when I have to understand why a package didn't run succesfully in a production enviroment, well, I can't run the package in debug mode from Visual Studio right from the production server (otherwise I'll be doing debugging on production machines, not an healthy way of working from my point of view)!

Another missing feature that I really missed a lot is the ability to profile dataflow tasks. To do a proper profiling you should add "Row Count" wherever you need to know how many rows has been processed, take the start and the end time of each transformation and put everything in a database for later analysis. This is a highly time consuming way to work IMHO, since package instrumentation should be something provided right from the execution tool, and not by who creates the pakages. Also, putting the instrumentation logic within the package make it more complex and long to develop.

DTLoggedExec 0.2.1.4 Beta Features:

· Enable / Disable logging on the fly for any package, just right from the command line
· Log Variables value
· Log Values of Properties bound to Expressions
· In case of error, log all properties along with related connection properties of the erroneous task. This is IDEAL for post-mortem debugging
· Fully pluggable architecture: decide where to log informations (natively supported: No Log, Console; CSV coming soon) Add your own log providers to customize logging
· Choose which event you want to log
· DTExec parameters emulation (not yet 100% finished)
· Compiled to support 32bit and 64bit platforms (32bit and 64bit executables are available in the zipped file)
· Support for Integration Services 2005 or 2008 through assembly binding
· DataFlow Profiling: log DataFlow performance data, how many rows each component has processed in how much time.

DTLoggedExec 0.2.1.4 Beta Requirements:

· Sql Server

DTLoggedExec security information

You cannot download any crack or serial number for DTLoggedExec on this page. Every software that you are able to download on our site is legal. There is no crack, serial number, hack or activation key for DTLoggedExec present here. Our collection also doesn't contain any keygens, because keygen programs are being used in illegal ways which we do not support. All software that you can find here is freely downloadable and legal.

DTLoggedExec installation package is prepared to be downloaded from our fast download servers. It is checked for possible viruses and is proven to be 100% clean and safe. Various leading antiviruses have been used to test DTLoggedExec, if it contains any viruses. No infections have been found and downloading DTLoggedExec is completelly problem free because of that reason. Our experts on malware detection tested DTLoggedExec with various spyware and malware detection programs, including fyxm.net custom malware and spyware detection, and absolutelly no malware or spyware was found in DTLoggedExec.

All software that you can find on our servers, including DTLoggedExec, is either freeware, shareware or open-source, some of the software packages are demo, trial or patch versions and if possible (public domain licence), we also host official full versions of software.

Because we want to be one of the fastest download sites on the web, we host all the software including DTLoggedExec on our servers. You cannot find here any torrents or download links that would lead you to dangerous sites.

Fyxm.net does support free software, however we do not support warez or illegal downloads. Warez is harming producers of the software.

Enjoy!