Getting Started with Adobe After Effects - Part 6: Motion Blur

Upload Image Close it
Select File

Career advice for the IT professional
Browse by Tags · View All
SQLServerPedia Syndication 194
SQL Server 60
2012/Denali 17
Career 17
Denali 14
SQL Server 2012 13

Archive · View All
June 2011 20
August 2011 15
July 2011 15
March 2012 15
October 2011 14
September 2011 14
May 2011 13
November 2011 12
February 2012 11
April 2012 10

James Serra's Blog

SQL Server 2012 (“Denali”): SSIS Logging

Jan 16 2012 12:00AM by James Serra   

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:

SSIS Reporting Pack

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

Republished with author's permission. See the original post here.

Republished from James Serra's Blog [70 clicks].  Read the original version here [32134 clicks].

James Serra
35 · 5% · 1664


Your Comment

Sign Up or Login to post a comment.

"SQL Server 2012 (“Denali”): SSIS Logging" rated 5 out of 5 by 1 readers
SQL Server 2012 (“Denali”): SSIS Logging , 5.0 out of 5 based on 1 ratings
    Copyright © Rivera Informatic Private Ltd Contact us      Privacy Policy      Terms of use      Report Abuse      Advertising      [ZULU1097]