• Online, Self-Paced
Course Description

SSIS can be installed during the SQL Server installation or as a separate component. Before installation, there are a number of factors needing consideration, such as upgrade options and architecture. This course will cover SSIS components.

Learning Objectives

Components of SSIS

  • start the course
  • describe SSIS components
  • prepare to install integration services
  • recognize the various SSIS configurations
  • install integration services using the setup wizard
  • use the SSIS designer graphical tool
  • describe when and how to use the development box and server
  • install specifics for remote package execution
  • plan for a 64-bit installation
  • upgrade SSIS components
  • provision accounts
  • create the catalog
  • describe catalog object identifiers
  • configure a catalog

Practice: Installing Integration Services

  • install integration services using the setup wizard

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.