+--------------------+ +-------------------+ +---------------------+ | Source System | ---> | Staging Table | ---> | Dimension (SCD) | | (e.g., OLTP DB) | | #Stg_Customer | | dbo.DimCustomer | +--------------------+ +-------------------+ +---------------------+
| Aspect | Description | |--------|-------------| | | SSIS‑586 – “Advanced SSIS Design, Performance, and Migration” | | Core Goal | Equip learners with deep technical expertise to design fault‑tolerant, high‑throughput SSIS solutions, integrate with Azure services, and adopt modern DevOps practices. | | Prerequisites | SSIS‑301/302 (fundamentals), solid T‑SQL knowledge, basic understanding of Windows Server/SQL Server architecture, exposure to Azure Data Factory (optional). | | Outcome | Participants will be able to: 1️⃣ Architect end‑to‑end ETL pipelines for terabytes of data. 2️⃣ Implement advanced error handling, logging, and package governance. 3️⃣ Optimize memory/CPU usage and tune data flow performance. 4️⃣ Migrate legacy SSIS packages to Azure Data Factory (ADF) / Azure Synapse. 5️⃣ Embed SSIS into CI/CD pipelines using Azure DevOps / Git. | ssis-586 english