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
Architecting Data Flows
- Introduction to data flow tasks and transformation logic
- Managing data sources and destinations
- Applying standard data transformations
- Addressing data quality challenges
Control Flow Management in SSIS
- Analyzing control flow tasks
- Leveraging containers for control flow orchestration
- Executing loops and conditional pathways
- Overseeing the execution sequence of packages
Advanced Transformation Strategies
- Utilizing complex transformation tools
- Data cleansing, validation, and enrichment processes
- Methods for aggregation and summarization
- Detailed implementation of Slowly Changing Dimensions (SCD)
Utilizing Variables and Parameters
- Basics of variables and parameters
- Employing variables to regulate package behavior
- Dynamic adjustment of package properties
Overseeing SSIS Package Execution
- Setting up execution configurations
- Strategies for error handling and logging
- Using event handlers to manage runtime occurrences
- Automation and scheduling via SQL Server Agent
Deployment and Package Administration
- Deployment models specific to SQL Server 2022
- Pushing packages to the SSIS catalog
- Monitoring and resolving issues in deployed packages
Optimizing Performance
- Detecting and resolving performance bottlenecks
- Best practices for tuning data and control flows
- Leveraging parallelism and batch processing in SSIS
Conclusion and Future Directions
Requirements
- Fundamental knowledge of SQL and relational database principles
- Proficiency with SQL Server Management Studio (SSMS)
Target Audience
- Data specialists
- Software developers
- Database administrators
