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
- Overview of data flow tasks and transformation mechanisms
- Integration of various data sources and destinations
- Application of standard data transformation techniques
- Strategies for resolving data quality issues
Control Flow in SSIS
- Analysis of control flow task functionalities
- Utilization of containers to structure control flow logic
- Incorporation of loops and conditional branching
- Management of package execution sequences
Advanced Data Transformation Techniques
- Implementation of advanced transformation components
- Data cleansing, validation, and enrichment workflows
- Techniques for data aggregation and summarization
- Detailed implementation of Slowly Changing Dimensions (SCD)
Working with Variables and Parameters
- Foundations of variables and parameter usage
- Leveraging variables to regulate package behavior
- Dynamic configuration of package properties
Managing SSIS Package Execution
- Configuration of execution settings and options
- Development of error handling and logging protocols
- Utilization of event handlers for runtime event management
- Automation and scheduling of executions via SQL Server Agent
Deploying and Managing SSIS Packages
- Exploration of deployment models in SQL Server 2022
- Deployment procedures to the SSIS catalog
- Monitoring strategies and troubleshooting for live packages
Performance Tuning and Optimization
- Identification and resolution of performance bottlenecks
- Best practices for enhancing data and control flow efficiency
- Application of parallelism and batch processing within SSIS
Summary and Next Steps
Requirements
- Fundamental knowledge of SQL and relational database principles
- Practical experience with SQL Server Management Studio (SSMS)
Intended Audience
- Data professionals
- Software developers
- Database administrators