Thank you for sending your enquiry! One of our team members will contact you shortly.
Thank you for sending your booking! One of our team members will contact you shortly.
Duration 14 hours
Course Outline
Data Flow Architecture
- Introduction to data flow tasks and transformation mechanisms
- Integration of various data sources and destinations
- Application of standard data transformations
- Strategies for addressing data quality challenges
Control Flow Management in SSIS
- Analysis of control flow task functionalities
- Leveraging containers to streamline control flow
- Implementation of loops and conditional branching
- Oversight of the package execution sequence
Advanced Transformation Methodologies
- Application of complex transformation features
- Techniques for data cleansing, validation, and enrichment
- Methods for aggregation and data summarization
- In-depth implementation of Slowly Changing Dimensions (SCD)
Utilization of Variables and Parameters
- Foundations of variables and parameter usage
- Controlling package behavior through variables
- Dynamic adjustment of package properties
Oversight of SSIS Package Execution
- Configuration of execution parameters
- Strategies for error handling and logging
- Management of runtime events via event handlers
- Automation and scheduling using SQL Server Agent
Deployment and Package Management
- Deployment models specific to SQL Server 2022
- Publishing packages to the SSIS catalog
- Monitoring and diagnostics for deployed packages
Performance Optimization
- Identification and resolution of performance bottlenecks
- Best practices for optimizing data and control flows
- Application of parallelism and batch processing in SSIS
Wrap-up and Future Directions
Requirements
- A fundamental grasp of SQL and relational database principles
- Working knowledge of SQL Server Management Studio (SSMS)
Target Audience
- Data professionals
- Developers
- Database administrators