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
- Introduction to data flow tasks and transformation components
- Managing data sources and destinations
- Applying standard data transformations
- Addressing data quality concerns
Control Flow in SSIS
- Exploring control flow task mechanisms
- Utilizing containers to govern control flow
- Creating loops and conditional branching logic
- Directing package execution sequences
Advanced Data Transformation Techniques
- Leveraging advanced transformation options
- Performing data cleansing, validation, and enrichment
- Applying aggregation and summarization methods
- Detailed implementation of Slowly Changing Dimensions (SCD)
Working with Variables and Parameters
- Overview of variables and parameter usage
- Using variables to influence package behavior
- Dynamically adjusting package properties
Managing SSIS Package Execution
- Setting package execution preferences
- Developing error handling and logging strategies
- Managing runtime events via event handlers
- Scheduling and automating runs using SQL Server Agent
Deploying and Managing SSIS Packages
- Deployment models in SQL Server 2022
- Publishing packages to the SSIS catalog
- Monitoring and diagnosing deployed packages
Performance Tuning and Optimization
- Detecting and resolving performance bottlenecks
- Applying best practices to optimize data and control flows
- Leveraging parallelism and batch processing in SSIS
Conclusion and Future Directions
Requirements
- Foundational knowledge of SQL and relational database principles
- Working proficiency with SQL Server Management Studio (SSMS)
Target Audience
- Data specialists
- Software developers
- Database administrators