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

Number of participants


Price per participant

Testimonials (1)

Upcoming Courses

Related Categories