Microsoft SSIS Real-time Scenarios (Package Design)

Course Curriculum

Chapter 1: Introduction

Lecture 1: Introduction

Lecture 2: Overview of all modules in the course

Chapter 2: Module 1: Using Derived Column transformation

Lecture 1: Overview of Module 1: Using Derived Column transformation

Lecture 2: Scenario 1: Adding static column and derive a column into the data flow pipeline

Lecture 3: Scenario 2: Adding user & system variables into the data flow pipeline

Chapter 3: Module 2: Executing SQL Stored Procedures

Lecture 1: Overview of Module 2: Executing SQL Stored Procedures

Lecture 2: Scenario 1: Calling stored procedure without parameters

Lecture 3: Scenario 2: Calling stored procedure with parameters that returns a scalar value

Lecture 4: Scenario 3: Calling stored procedure with parameters that returns a dataset

Chapter 4: Module 3: Implementing SSIS flexibility using Expressions

Lecture 1: Overview of Module 3: Implementing SSIS flexibility using Expressions

Lecture 2: Scenario 1: Exp – Controlling precedence constraints (Logical conditioning)

Lecture 3: Scenario 2: Exp – Creating a dynamic SQL statement

Lecture 4: Scenario 3: Exp – Extracting path or filename from full path

Lecture 5: Scenario 4: Exp (Way-1) – Separate numeric & string values of a column

Lecture 6: Scenario 4: Exp (Way-2) – Separate numeric & string values of a column

Lecture 7: Conclusion Module 3: Implementing SSIS flexibility using Expressions

Chapter 5: Module 4: Using Import Column & Export Column transformations

Lecture 1: Overview of Module 4: Using Import Column & Export Column transformations

Lecture 2: Scenario 1: Import/export – Importing files as blob into table

Lecture 3: Scenario 2: Import/export – Exporting files back from blob

Chapter 6: Module 5: Extending SSIS functionalities using Scripts (C# or VB.Net)

Lecture 1: Overview Module 5: Extending SSIS functionalities using Scripts (C# or VB.Net)

Lecture 2: Scenario 1: Script Task – Zip and Unzip compressed files

Lecture 3: Scenario 2: Script Task – Get list of specific files from multilevel directory

Lecture 4: Scenario 3: Script Task – Load a delimited file into SQL

Lecture 5: Scenario 4: Script Task – Download file from http(s) URL

Lecture 6: Scenario 5: Script Task – Convert a JSON file into csv

Lecture 7: Scenario 6: Script Task – Validate header (HDR) and trailer (TLR) of a file

Lecture 8: Conclusion Module 5: Extending SSIS functionalities using Scripts (C# or VB.Net)

Chapter 7: Module 6: Using SSIS FOREACH & FOR LOOP Containers

Lecture 1: Overview of Module 6: Using SSIS FOREACH & FOR LOOP Containers

Lecture 2: Scenario 1: Loop Container – Loop though a collection of files in an object

Lecture 3: Scenario 2: Loop Container – Repeat a task for dates between 2 dates

Chapter 8: Module 7: Loading delimited flat files into SQL database tables

Lecture 1: Overview of Module 7: Loading delimited flat files into SQL database tables

Lecture 2: Scenario 1: Flat file – loading a CSV file

Lecture 3: Scenario 2: Flat file – loading a TSV file

Lecture 4: Scenario 3: Flat file – loading a PSV file

Lecture 5: Scenario 4: Flat file – loading a SSIS Raw file

Chapter 9: Module 8: Loading data, Incremental Load & SCD-2 + more

Lecture 1: Overview of Module 8: Loading data, Incremental Load & SCD-2 + more

Lecture 2: Scenario 1: Extracting numeric from a alphanumeric string values of a column

Lecture 3: Scenario 2: Generic ETL (load a table with load date into destination)

Lecture 4: Scenario 3: Flush and load or truncate and load, full load every time

Lecture 5: Scenario 4 (Part-1): Merging data from multiple sources and loading into table

Lecture 6: Scenario 4 (Part-2): Merging data from multiple sources and loading into table

Lecture 7: Scenario 5: (Way-1) Pivoting the data and load into a table

Lecture 8: Scenario 5: (Way-2) Pivoting the data and load into a table

Lecture 9: Scenario 6: Implementing slowly changing dimension (SCD) type 2

Lecture 10: Scenario 7.1.1: Implementing incremental/delta data load (ADO NET Connection)

Lecture 11: Scenario 7.1.2: Implementing incremental/delta data load (ADO NET Connection)

Lecture 12: Scenario 7.2: Implementing incremental/delta data load (OLE DB Connection)

Lecture 13: Scenario 8: – Import data from table into flat file with transformation

Chapter 10: Module 9: Package restart ability using Check point + Using Execute Process Task

Lecture 1: Overview: Package restart ability using Check point + Using Execute Process Task

Lecture 2: Scenario 1: Implementing check points in a SSIS package

Lecture 3: Scenario 2: Executing “Python” & "R" script using Execute Process Task

Chapter 11: Congratulations & Conclusion

Lecture 1: Congratulations