SSIS includes logging features that write log entries when run-time events occur
and can also write custom messages. This is not enabled by default. Integration
Services supports a diverse set of log providers, and gives you the ability to create
custom log providers. The Integration Services log providers can write log entries
to text files, SQL Server Profiler, SQL Server, Windows Event Log, or XML files.
Logs are associated with packages and are configured at the package level. Each
task or container in a package can log information to any package log. The tasks
and containers in a package can be enabled for logging even if the package itself
is not.