Making the Most of the SSIS Catalog

Managing the SQL Server Integration Services (SSIS) ecosystem became significantly easier with the addition of the SSIS catalog in SQL Server 2012. The SSIS catalog offered many new features that made often-laborious tasks such as logging, parameterization, and variable collections much easier to develop and manage. For the SSIS developer as well as the operations staff in charge of day-to-day package execution, using the SSIS catalog helps to make their jobs easier by eliminating several tedious and error-prone processes. In this session, we will survey and demonstrate many of the useful features of the SSIS catalog. We will discuss the structure of the catalog and review how it changes the way we interact with deployed packages in SSIS. We will also demonstrate how parameters and SSIS environments help to ease the burden of supplying runtime configuration values to packages. In addition, we will demonstrate how package logging is a far simpler exercise in the new SSIS catalog.

• Tim Mitchell

  5 Recordings

  Tim Mitchell is a business intelligence consultant, author, and trainer. He has worked with SQL Server for over a decade, specializing in data warehousing, ETL/SSIS, and reporting. He holds a Bachelor’s Degree in Computer Science from Texas A&M at Commerce, and is recognized as a Microsoft Data Platform MVP. Tim is a business intelligence consultant and principal at Tyleris Data Solutions. Tim is an active community speaker and volunteer, having spoken at over 100 events including the PASS Summit, SQLBits, Dev Connections, SQL Intersection, and scores of SQL Saturdays. He blogs at TimMitchell.net, and tweets at @Tim_Mitchell.

• Houston SQL Saturday 43 Recordings

• SSIS 9 Recordings