SSIS 2014, Part 11 of 11: Security

with Don Kiely

In this course, you’ll start by learning about the typical threats that the security tools in Integration Services help protect against. Then you’ll learn how to control access to packages stored in the Package Store in SQL Server, about the available roles and how to create a custom role, as well as how to sign a package with a digital certificate. Then you’ll learn about the new security features that come with the SSIS Catalog introduced in SQL Server 2012, which more closely emulates the security scheme in the SQL Server database engine.

Course Outline