• Online, Self-Paced
Course Description

SSIS consists of several layers, including package properties and centralized management, to provide a rich and flexible environment. This course covers SSIS catalog creation and package deployment.

Learning Objectives

SSIS Solutions

  • Start the course
  • understanding the SSIS catalog
  • backup and restore the SSIS catalog
  • upgrade the SSIS catalog
  • create a deployment utility
  • deploy SSIS packages using the deployment utility
  • deploy SSIS packages to SQL or file system locations
  • deploy packages on multiple servers
  • validate deployed packages
  • install custom components and tasks
  • deploy SSIS packages using DTUTIL

Framework Connections

The materials within this course focus on the Knowledge Skills and Abilities (KSAs) identified within the Specialty Areas listed below. Click to view Specialty Area details within the interactive National Cybersecurity Workforce Framework.