SSIS Practice Exercises

A repository for the practice exercises of Microsoft SQL Server Integration Service (SSIS for short, it is ETL tool) while digging deep on understanding and practicing the tool. You can find the exercises packages here and the correponding files here.

Topics Covered (its synonym to track the folder and the package)

1. Data Flow Tasks (DFT).
2. Basic Data Transformations (BDT).
3. Data Conversion Tranforms (DCT).
4. Conditional Split Tranforms (CST).
5. Lookup Transforms (LUT).
6. Looping Over Files (LOF).
7. Looping Over Rows (LOR).
8. Merge Joins (MJ).
9. Script Tasks (ST).
10. Variables In Script (VIS).
11. Script Components (SC).

Tools Used

1. Microsoft SQL Server Integration Service (SSIS).
2. Microsoft SQL Server Management Studio (SSMS).
3. Microsoft Excel.

Websites Used

1. WiseOwl SSIS Exercises
2. WiseOwl SSIS Course

Snapshots