In previous SSIS versions as the developer you were responsible for configuring all of your logging options, such as what events you were going to log, which containers you were going to collect logs for, and where you were going to store those logs.
In SSIS for SQL Server 2012 that all goes away. The SSIS server is responsible for managing all of your deployed projects/packages and in turn manages both the execution of them and the collection of log information. Instead of having lots of options for logging we now have a definitive one and over time it is the one that everyone will use.
In SQL Server 2012, the SSIS catalog is the central storage and administration point for SSIS projects, packages, parameters and environments, and handles all the logging. This catalog is part of a new and optional SSIS deployment model called the “Project Deployment Model” along with traditional “Legacy Deployment Model”.
SSIS catalog automatically captures logs for packages run on the server. The logging level is set to Basic by default, and can be set higher to capture more info. The data in stored in eight different views under the “catalog” schema, and contains a ton of info. Jamie Thomson does a great job covering these views at SSIS Logging in Denali.
More info:
Views (Integration Services Catalog)
Setting a Default Logging Level in the SSIS Catalog
What Events are Included in the SSIS Catalog Log Levels
Report Authoring on the SSIS Catalog
Video What’s New in Microsoft SQL Server Code-Named “Denali” for SQL Server Integration Services
Is the SSIS Catalog going to be enough?
