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