SQL Server 2022 Integration Services (SSIS) – Data Flows and Advanced Transformations Training Course

Designing Data Flows

• An overview of data flow tasks and transformation components.
• Integrating various data sources and destinations.
• Applying standard data transformation techniques.
• Strategies for addressing data quality challenges.

Control Flow in SSIS

• An understanding of control flow task mechanics.
• Utilizing containers to orchestrate control flow.
• Implementing loops and conditional logic for dynamic execution.
• Managing the overall package execution flow.

Advanced Data Transformation Techniques

• Leveraging advanced transformation tools.
• Performing data cleansing, validation, and enrichment.
• Applying aggregation and summarization methods.
• A detailed implementation of Slowly Changing Dimensions (SCD).

Working with Variables and Parameters

• An introduction to the role of variables and parameters.
• Using variables to dictate package behavior and logic.
• Dynamically configuring package properties.

Managing SSIS Package Execution

• Configuring execution options for optimal performance.
• Establishing effective error handling and logging strategies.
• Employing event handlers to manage runtime events.
• Scheduling and automating execution via SQL Server Agent.

Deploying and Managing SSIS Packages

• Exploration of deployment models in SQL Server 2022.
• Deploying packages to the SSIS Catalog.
• Techniques for monitoring and troubleshooting deployed packages.

Performance Tuning and Optimization

• Identifying and resolving performance bottlenecks.
• Adhering to best practices for optimizing data and control flows.
• Leveraging parallelism and batch processing within SSIS.

Summary and Next Steps