SSIS Security

Overview/Description
Target Audience
Prerequisites
Expected Duration
Lesson Objectives
Course Number
Expertise Level

---

Overview/Description
SSIS consists of several layers, including digital signatures and database roles, to provide a rich and flexible security environment. This course covers techniques and recommendations on how to secure an SSIS deployment.

Target Audience
Data warehouse developers and database administrators who create and manage business intelligence solutions as part of their daily tasks, which include implementing data warehouse databases, extracting and transforming data as part of an ETL solution, and data cleansing

Prerequisites
None

Expected Duration (hours)
1.1

Lesson Objectives

SSIS Security

start the course

describe the SSIS catalog database roles

describe the parameters and package deployment model

describe the parameters and project deployment model

describe the different package protection levels

describe options available in the Package and Project Protection Level dialog box

configure secure deployments using project and package protection levels

secure integration services packages deployed at the file system

create sensitive parameters

set parameter values post deployment

implement SSIS security

Course Number:
md_idwm_a17_it_enus

Expertise Level
Intermediate