Course Outline
Introduction to SQL Server Integration Services (SSIS)
- Overview of SSIS and its role in data integration
- Key features and enhancements in SQL Server 2022
- SSIS architecture and components
- Understanding ETL processes
Getting Started with SSIS
- Installing and configuring SSIS
- Introduction to SQL Server Data Tools (SSDT)
- Creating your first SSIS project and package
- Navigating the SSIS designer interface
Designing Data Flows
- Introduction to data flow tasks and transformations
- Working with data sources and destinations
- Implementing common data transformations
- Handling data quality issues
Control Flow in SSIS
- Understanding control flow tasks
- Using containers to manage control flow
- Implementing loops and conditional logic
- Managing package execution flow
Advanced Data Transformation Techniques
- Using advanced transformations
- Implementing data cleansing and validation
- Performing data enrichment and aggregation
- Using fuzzy matching and grouping
Working with Variables and Parameters
- Introduction to variables and parameters
- Using variables to control package behavior
- Passing parameters to and from packages
- Dynamic configuration of package properties
Managing SSIS Package Execution
- Configuring package execution options
- Implementing error handling and logging
- Using event handlers to manage runtime events
- Scheduling and automating package execution with SQL Server Agent
Deploying and Managing SSIS Packages
- Overview of SSIS deployment models
- Deploying packages to the SSIS catalog
- Managing package configurations and environments
- Monitoring and troubleshooting deployed packages
Performance Tuning and Optimization
- Identifying performance bottlenecks in SSIS packages
- Best practices for optimizing data flows and control flows
- Using SSIS logging and performance counters
- Implementing parallelism and batch processing
Advanced Topics and Future Directions
- Introduction to SSIS scripting with C# and VB.NET
- Integration with other SQL Server components
- Exploring new features and enhancements in future SSIS releases
- Resources for further learning and community involvement
Summary and Next Steps
Requirements
- Basic understanding of SQL and relational database concepts
- Familiarity with SQL Server Management Studio (SSMS)
Audience
- Data professionals
- Developers
- Database administrators
Custom Corporate Training
Training solutions designed exclusively for businesses.
- Customized Content: We adapt the syllabus and practical exercises to the real goals and needs of your project.
- Flexible Schedule: Dates and times adapted to your team's agenda.
- Format: Online (live), In-company (at your offices), or Hybrid.
Price per private group, online live training, starting from 6400 € + VAT*
Contact us for an exact quote and to hear our latest promotions
Testimonials (1)
The adjustment made in the lecture/lessons by the trainer once he understood the current SSIS application that we are bound to maintain. The topics became more suitable/usable to us.
