Details

Deep Dive into the SSIS Catalog

Tim Mitchell
60 minutes
BI Platform Architecture, Dev, Delivery & Admin
Intermediate
The SSIS catalog is one of the best-evolved features in the SQL Server Integration Services ecosystem. With integrated package storage, Windows ACL-like security settings, built-in logging, and many other features, the SSIS catalog has become an anchor for many ETL architectures. With all this complexity, it is important to understand the inner workings of the SSIS catalog to keep it running smoothly. In this demo-heavy presentation, we will dive into the details of the SSIS catalog. We will start with a quick survey of catalog features, followed by an exploration of the moving parts (tables, views, and stored procedures) in the catalog database. We will also review the security capabilities in the catalog, and will discuss maintenance operations. Finally, we'll walk through the mechanics of deployment and execution, reviewing what happens under the covers during these operations.
Attendees should have a basic understanding of SSIS packages, ideally with some experience actually developing packages.

Accompanying Material

No material found.


Back to Top cage-aids
cage-aids
cage-aids
cage-aids