Denali

What’s New in SSIS for SQL Server 2012 – Slide Deck

The slide deck for the What’s New in SQL Server Integration Services in SQL Server 2012 presentation is now available (embedded below). Typically when I present the new functionality in SQL 2012, I stick to demos… but I put together this deck to show off most of the new features in slide form. Enjoy!  

SSIS Quick Tip: Required Parameters

SSIS Quick Tip: Required Parameters

SQL Server 2012 introduces the new Parameter model. Setting a parameter’s Required property to True means that a value must be supplied at runtime by the caller of the package (dtexec, SSMS, SQL Agent, the Execute Package Task, etc). This means that although the parameter has a default value at design time, it will never … Continued

Setting a Default Logging Level in the SSIS Catalog

Setting a Default Logging Level in the SSIS Catalog

One of the powerful features of the SSIS Catalog is that it can automatically capture logs for packages run on the server. The logging level is set to Basic by default, and can be changed when the package is run on the Advanced tab of the run UI (as shown below. This can also be … Continued

What Events are Included in the SSIS Catalog Log Levels

Logging Levels Packages run through the SSIS Catalog can automatically have their logs captured in SQL Server 2012. The SSIS Catalog provides four different log levels – None, Basic, Performance, Verbose. The default log level is Basic. The table below shows which SSIS events are captured in the [catalog].[operation_messages] view in the four logging levels. … Continued

Upcoming Book – SSIS Design Patterns

Upcoming Book – SSIS Design Patterns

Over the past few months I’ve been working on a book for SQL Server 2012 entitled – SSIS Design Patterns. I’m co-authoring the book with a fantastic bunch of SQL Server MVPs – Tim Mitchell, Jessica Moss, Michelle Ufford, and Andy Leonard. Details are now available on the Apress website and Amazon. SSIS Design Patterns … Continued