3.6.1 Extract, Transform & Load - Checklist of Activities

Lesson 6: Extract, Transform & Load - Checklist Activities

Learning Activities

Review the lesson lecture

Lesson 6: Write Data Integration Scripts Lecture Notes 60:00 minutes

Read the textbooks

Knight's Microsoft SQL Server 2012 Integration Services 24-hour Trainer 136:00 minutes

Chapter 10-11 pages 63-78
Chapter 13-16 pages 87-112
Chapter 20-21 pages 151-165
Chapter 42-43 pages 331-343

Microsoft SQL Server 2012 Step by Step Chapter 28 pages 365-378 26:00 minutes

Review the lesson videos

Database Mail 6:48 minutes
SSIS - Moving Files Using Variables 4:08 minutes
SSIS Basic Transformations 21:43 minutes
Lookup Transforms 25:41 minutes
Sequence Containers and FOR Loops 15:44 minutes
Looping Over Files 21:43 minutes
Other Foreach Loops 22:42 minutes
Script Components 19:05 minutes
SSIS Script Tasks 16:35 minutes

Review websites as referred to in lesson content. 15:00 minutes

Assessment Activities

Complete the Lesson 6: Lab 120:00 minutes
Complete the Lesson 6: Assignment 120:00 minutes
Complete the Lesson 6: Group Assignment 120:00 minutes