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.
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.
28 Hours
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.
