SSIS
provides a granular level of control in deciding what to log and where to
log. To enable event logging for an SSIS Package, right click in the
control flow area of the package and click on Logging. In the Configure
SSIS Logs window you will notice all the tasks of the package are listed on
the left side of the tree view. You can specifically choose which tasks
you want to enable logging. On the right side you will notice two tabs; on
the Providers and Logs tab you specify where you want to write the logs,
you can write it to one or more log providers together. On the Details tab
you can specify what events do you want to log for the selected task.
Please
note, enabling event logging is immensely helpful when you are
troubleshooting a package, but also incurs additional overhead on SSIS in order
to log the events and information. Hence you should only enabling event
logging when needed and only choose events which you want to log. Avoid
logging all the events unnecessarily.
No comments :
Post a Comment