Logging Package Execution

Microsoft SQL Server Integration Services includes logging features that expose run-time events for logging, support a diverse set of logging providers, and provide commonly requested information for logging. Information can be logged to text files, SQL Server Profiler, the sysssislog table in a SQL Server database, the Windows Event Log, and XML files. For more information, see Integration Services Log Providers.

Packages can be configured to use logging by using SSIS Designer, the graphical tool for creating packages that Integration Services provides, or programmatically. For more information about how to enable a package and its containers and tasks for logging, see Implementing Logging in Packages.

You can also include logging when you run a package using the dtexec command prompt utility. For more information about the command prompt arguments that support logging, see dtexec Utility (SSIS Tool).