embed embed share link link comment comment

Embed This Video close
Share This Video close
bookmark bookmark bookmark bookmark bookmark bookmark bookmark bookmark bookmark bookmark bookmark bookmark
embed test
Rate This Video embed
1 Star2 Stars3 Stars4 Stars5 Stars (No Ratings Yet)
Loading ... Loading ...
Tags For This Video tags
rate rate tags tags related related lights lights

Making the Most of the SSIS Catalog


Tim Mitchell


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 is a business intelligence consultant, author, and trainer. He has been working with SQL Server for over a decade, working primarily in business intelligence, ETL/SSIS, data quality, and reporting. He holds a Bachelor’s Degree in Computer Science from Texas A&M at Commerce, and has been a Microsoft SQL Server MVP since 2010. Tim is an independent business intelligence consultant and a partner with Linchpin People, and is the principal of Tyleris Data Solutions.

Recorded At:

SQL Saturday Houston 2016

Leave a Reply

Your email address will not be published. Required fields are marked *


You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>