• Online, Self-Paced
Course Description

SSIS provides the ability to create custom components if the integrated components do not suit their needs. In this course, you'll learn how to develop and install custom components and implement script tasks.

Learning Objectives

Script Components

  • start the course
  • describe SCD type 1, 2 and 3 changes
  • describe script components in SSIS
  • decide when it is appropriate to use a script component vs. a built-in source component
  • decide when it is appropriate to use a script component vs. a built-in transformation component
  • decide when it is appropriate to use a script component vs. a built-in destination component
  • describe use cases such as web service source and destination
  • describe how to resolve potential error messages

Practice: SSIS Custom Components and SCD

  • use SSIS custom components and SCD

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.