Export (0) Print
Expand All
This topic has not yet been rated - Rate this topic

Logging Package Execution

Microsoft SQL Server 2005 Integration Services (SSIS) 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 sysdtslog90 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.

After a package finishes running, you can view the run-time information in the package logs.

The following table describes the location of the logs to which Integration Services log providers write.

Log provider Location

Text File

The File connection manager that the log provider uses specifies the path of the text file.

SQL Server Profiler

The File connection manager that the log provider uses specifies the path of the file used by SQL Server Profiler.

Windows Event Log

The Application log in Windows Event Viewer contains the Integration Services log information.

SQL Server

The OLE DB connection manager that the log provider uses specifies the SQL Server database that contains the sysdtslog90 table with the log entries.

XML File

The File connection manager that the log provider uses specifies the path of the XML file.

Did you find this helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft. All rights reserved.