- SSIS Introduction
- Architecture and Components of SSIS
- Packages
- Sources
- CSV
- JSON
- Parquet
- DB Tables
- DB Views
- DB SQL Statements
- Targets
- CSV
- JSON
- Parquet
- DB Tables
- DB Views
- DB SQL Statements
- SSIS Transformations
- Union All
- Sort
- Multicast
- Merge Join
- Merge
- Lookup
- Derived column
- Data Conversion
- Type Casting Copy Column
- Group by
- pivot
- Control Flow Tasks
- Containers
- Sequence
- for loop
- for each loop Event Handlers
- Common Tasks Containers Data Flow
- Parameters Event Handlers Execution
- Precedence Constraint Variables Expressions
- Event Handlers
- Execute Package Task
- (Parent - Child Package)
- Blocking
- Non Blocking
- Semi Blocking
- Performance Improvement
- Logging
- SSIS Catalog (Deployment) Sql Server Agent (Schedule Jobs)
- FTP Site Files to SQL Server
- BLOB Files to SQL Server **
- MySQL Docker DB to SQL Server
- OLTP to FILE to OLAP