Log Events

The following is a list of log events you might see in your logs and a description of each. The stock log events are those log events that the IS runtime registers and logs whenever there is an event of the same name. These log events will always be available for all containers. Table 11.2 shows those log events.

Table 11.2. Stock Log Events

Event Log Entry	Description
OnError	Writes a log entry when an error occurs
OnExecStatusChanged	Writes a log entry when the execution status of the executable changes
OnInformation	Writes a log entry during the validation and execution of an executable to report information
OnPostExecute	Writes a log entry immediately after the executable has finished running
OnPostValidate	Writes a log entry when the validation of the executable finishes
OnPreExecute	Writes a log entry immediately before the executable runs
OnPreValidate	Writes a log entry when the validation of the executable starts
OnProgress	Writes a log entry when measurable progress is made by the executable
OnQueryCancel	Writes a log entry at any juncture in the task processing where it is feasible to cancel execution
OnTaskFailed	Writes a log entry when a task fails
OnVariableValueChanged	Writes a log entry when the value of a variable changes
OnWarning	Writes a log entry when a warning occurs

The stock task log events are those log events that IS stock tasks register and log. These log events are only available in and logged from the specific tasks noted. Table 11.3 shows the stock task log events.

Table 11.3. Stock Task Log Events

Task Name	Log Event Name	Description
Execute SQL	ExecutingQuery	Logs entry with the query
Bulk Insert	Begin	Logs when task begins insert
Bulk Insert	End	Logs when task completes insert
Bulk Insert	TaskInfo	Logs the bulk insert task information, such as row delimiters, column delimiters, format file path, source connection, destination connection, destination table name, and data file type
Data Flow	BufferSizeTuning	Logs when the Data Flow Task changes the buffer size and it is different from the default values and includes buffer size and reasons for the change
Data Flow	BufferLeak	Logs when a transform holds onto buffer references and should be releasing them; useful for building custom transforms
Data Flow	ExecutionPlan	Logs the execution plan
Data Flow	ExecutionTrees	Logs the input the Data Flow Task scheduler was given when forming the execution plan
Data Flow	Initialization	Logs Data Flow Task initialization information, such as Buffer Size, Buffer Row Size, and Not Optimized Mode
Execute DTS 2000 Package	TaskBegin	Logs when the DTS package starts executing
Execute DTS 2000 Package	TaskEnd	Logs when the DTS package completes executing
Execute DTS 2000 Package	TaskInfo	Logs information about the DTS 2000 Package, such as the package name and package location
Execute DTS 2000 Package	TaskResult	Logs the result of the task
Execute Process	ExecutingProcess	Logs information about the process, such as the executable name, working directory, window style, and so on
Execute Process	Variable Routing	Logs the name of the variables where the task will store Standard Input, Standard Output, and Standard Error
File System	Operation	Logs the operation the task performed, including copy, delete, create directory, and so on
FTP	ConnectingToServer	Logs when the task attempts to connect to the FTP server
FTP	Operation	Logs the operation the task performed, including get, put, create directory, and so on
MSMQ	AfterOpen	Logs after the queue is opened for reading
MSMQ	BeforeOpen	Logs before the queue is opened for reading
MSMQ	BeginReceive	Logs before receiving the message
MSMQ	BeginSend	Logs before sending the message
MSMQ	EndReceive	Logs after receiving the message
MSMQ	EndSend	Logs after sending the message
MSMQ	TaskInfo	Logs task information, such as the queue type, queue path, use DTS 2000 format, encryption enabled, encryption algorithm, message type, and so on
MSMQ	TaskTimeOut	Logs when a timeout occurs while receiving a message
Script	LogEntry	User-generated log entries. Can be logged anytime with any description and content
Send Mail	TaskBegin	Logs when task begins sending
Send Mail	TaskEnd	Logs when sending completed
Send Mail	TaskInfo	Logs information about the task, such as To, From, CC, Subject, Priority, and so on
Transfer Database	DestSQLServer	Logs the destination server instance name
Transfer Database	SourceDB	Logs the source database name
Transfer Database	SourceSQLServer	Logs the source server instance name
All Transfer Tasks	FinishedTransferringObjects	Logs when task completes transfer of error messages
All Transfer Tasks	StartTransferringObjects	Logs when task starts to transfer error messages
Web Services	WSTaskBegin	Logs before executing web methods
Web Services	WSTaskEnd	Logs after executing web methods
Web Services	WSTaskInfo	Logs task information, such as connection name, service name, output type, output location, and web method
WMI Data Reader	Operation	Logs the WMI query used to retrieve data
WMI Event Watcher	EventOccurred	Logs when the event the task was waiting for occurred
WMI Event Watcher	EventTimedOut	Logs when the task is waiting for an event and times out
XML	Operation	Logs the operation the task will perform, including diff, merge, patch, XSLT, XPath, and Validate