SSIS: Logging

Logging is used to log the information during the execution of package.

                    To effectively monitor SSIS performance, troubleshoot errors, and understand data lineage in a production environment, you need to implement package logging and data auditing.
            Package logging refers to writing information about the execution results of a package, and its tasks. During package execution, SSIS can log many types of events (e.g., status, completion, error information about a task) to a variety of destinations, known as log providers. A log provider can be a text file, the SQL Server Profiler, a SQL Server relational database, a Windows event log, or an XML file. If necessary, you can define a custom log provider (e.g., a proprietary file format).
         You configure logging at the package level by adding a log provider. You can choose to log only certain tasks within a package. When designing a package in BIDS, click Logging on the SSIS menu to display the Configure SSIS Logs dialog box. Use the Providers and Logs tab to select a provider to use for the container.

There are 2 places from where you can launch the logging wizard. 

1. Right click on anywhere in the package there will be an option called Logging click on that. 

2. You can go to the top menu and from where you can select SSIS and inside that you find an option for Logging.

A log provider can be a text file, the SQL Server Profiler, a SQL Server relational database, a Windows event log, or an XML file.

If necessary, you can define a custom log provider (e.g., a proprietary file format).

When you have added a log provider to your package, click the Details tab and select the events you want to log. Some of the event choices include:

OnError: writes a log entry when an error occurs
OnPost Execute: writes a log entry after a task or package finishes running.
OnVariableValueChanged: logs an entry when a variable value changes. 

To prevent the log from becoming unnecessarily large and to avoid degrading performance, log only the events you need.

SSIS packages, tasks and containers have a property called LoggingMode. 
This property accepts 3 possible values: 

Enabled - to enable logging of that component 

Disabled - to disable logging of that component

UseParentSetting - to use parent's setting of that component to decide whether or not to log the data.