SSIS: How do you do logging in SSIS?

Answer:


SSIS includes logging features that write log entries when run-time events occur and can also write custom messages.


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.


To customize the logging of an event or custom message, Integration Services provides a schema of commonly logged information to include in log entries. The Integration Services log schema defines the information that you can log. You can select elements from the log schema for each log entry.


To enable logging in a package


1. In Business Intelligence Development Studio, open the Integration Services project that contains the package you want.


2. On the SSIS menu, click Logging.


3. Select a log provider in the Provider type list, and then click Add.

SSIS Interview Questions And Answers