General Informations
As the name suggests, the Console Log Provider will output all logging information to the Console.
The Console Log Provider is the default log provider, so if the parameter /LP is not specified as DTLoggedExec argument, this provider will be used.
Using the Log Provider
The power of the Console Log Provider lies in the possibility that the Command Prompt offers to direct everything to a text file, using the ">" operator:
"C:\DTLoggedExec\Any\DTLoggedExec.exe" /FILE:"C:\Work\SSIS Logging\DTLoggedExec\TestPackages\TestPackages\Test Package 1.dtsx" > TestPackage1.output.txt
This is the result:
This technique is very useful since assures you that
every information that DTLoggedExec needs to print out will be logged in the destination text file.
Logged data
Each time an event gets trapped (basing on the /LE option specified as
DTLoggedExec parameter) the Console Log Provider will log for each event - and thus for reach task that has generated the event - the following data:
PackageName
The name of the package that contains the task. This is very useful when you have complex solution where packages invoke other packages. It allows you to understand that, even if you executed Package1, the error happened in Package2, called by Package1.
This situation can be seen the above sample.
Task Type
The .NET type of the task.
Description
The user defined task description.
Object ID
The GUID assigned to the task at development time.
Container Name
The name of the container that contains the task.
Container ID
The GUID assigned to the container that contains the task.
StartTime
Time at which the task started its work.
EndTime
Time at which the task finished its work.
Message
Message generated by the task for the logged event.
Variables
All the variables that the task can see along with their values.
Expressions
All the DTS expression active on the task, along with their resulting values.
Properties
All the properties of the task, along with their run-time values. For sensitive data like password, the values are not displayed.
Usage
Console Log Provider is specially useful when scheduling packages through the SQL Server Agent. Check out the
Scheduling packages via SQL Server Agent page to learn more on this,
Configuring the Log Provider
Console Log Provider does not support any optional arguments and thus doesn't need to be configured.