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
Designing Data Flows
- Exploring the landscape of data flow tasks and transformations
- Integrating various data sources and destinations
- Applying standard data transformation methods
- Resolving data quality challenges
Control Flow in SSIS
- Gaining insight into control flow mechanisms
- Leveraging containers to orchestrate control flow
- Integrating loops and conditional branching logic
- Regulating the overall package execution sequence
Advanced Data Transformation Techniques
- Utilizing specialized transformation capabilities
- Performing data cleansing, validation, and enrichment
- Applying aggregation and summarization methods
- Detailed implementation of Slowly Changing Dimensions (SCD)
Working with Variables and Parameters
- Fundamentals of variables and parameters
- Utilizing variables to modulate package behavior
- Implementing dynamic configuration for package properties
Managing SSIS Package Execution
- Setting up package execution preferences
- Developing error handling and logging strategies
- Employing event handlers to address runtime occurrences
- Scheduling and automating execution via SQL Server Agent
Deploying and Managing SSIS Packages
- Examining deployment models in SQL Server 2022
- Deploying packages to the SSIS catalog
- Monitoring and diagnosing deployed packages
Performance Tuning and Optimization
- Identifying and resolving performance bottlenecks
- Adopting best practices for optimizing data and control flows
- Leveraging parallelism and batch processing in SSIS
Summary and Next Steps
Requirements
- Foundational knowledge of SQL and relational database principles
- Working familiarity with SQL Server Management Studio (SSMS)
Target Audience
- Data professionals
- Software developers
- Database administrators