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
- Fundamentals of data flow tasks and transformations.
- Integration with various data sources and destinations.
- Application of standard data transformations.
- Strategies for addressing data quality challenges.
Control Flow in SSIS
- Core concepts of control flow tasks.
- Leveraging containers to orchestrate control flow.
- Implementation of loops and conditional logic.
- Orchestrating the overall package execution flow.
Advanced Data Transformation Techniques
- Utilization of complex transformation components.
- Processes for data cleansing, validation, and enrichment.
- Methods for aggregation and data summarization.
- In-depth implementation of Slowly Changing Dimensions (SCD).
Working with Variables and Parameters
- Overview of variable and parameter usage.
- Utilizing variables to regulate package behavior.
- Dynamic configuration of package properties.
Managing SSIS Package Execution
- Setting package execution preferences.
- Development of error handling and logging frameworks.
- Utilization of event handlers for runtime event management.
- Scheduling and automation via SQL Server Agent.
Deploying and Managing SSIS Packages
- Deployment strategies specific to SQL Server 2022.
- Publishing packages to the SSIS catalog.
- Monitoring and resolving issues in deployed packages.
Performance Tuning and Optimization
- Identification and resolution of performance bottlenecks.
- Best practices for optimizing both data and control flows.
- Optimizing parallelism and batch processing in SSIS.
Summary and Next Steps
Requirements
- Foundational knowledge of SQL and relational database principles.
- Proficiency in using SQL Server Management Studio (SSMS).
Target Audience
- Data professionals.
- Software developers.
- Database administrators.