Script Components

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