Script Components


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


Overview/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.

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)
0.8

Lesson 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
  • use SSIS custom components and SCD

    • Course Number:
    md_idwm_a12_it_enus

    Expertise Level
    Intermediate