Get in Touch
 Duration 14 hours

Course Outline

Data Flow Design

  • Fundamentals of data flow tasks and transformations
  • Managing data sources and destinations
  • Application of standard data transformations
  • Addressing data quality concerns

Control Flow in SSIS

  • Concepts of control flow tasks
  • Utilizing containers to orchestrate control flow
  • Implementing loops and conditional branching logic
  • Overseeing package execution sequences

Advanced Transformation Strategies

  • Leveraging advanced transformation capabilities
  • Data cleansing, validation, and enrichment processes
  • Methods for aggregation and summarization
  • In-depth implementation of Slowly Changing Dimensions (SCD)

Variables and Parameters

  • Basics of variables and parameters
  • Utilizing variables to modulate package behavior
  • Dynamic configuration of package properties

Package Execution Management

  • Setting up package execution parameters
  • Strategies for error handling and logging
  • Managing runtime events via event handlers
  • Automation and scheduling through SQL Server Agent

Deployment and Administration

  • Deployment architectures in SQL Server 2022
  • Deploying packages to the SSIS catalog
  • Monitoring and diagnosing deployed packages

Performance Tuning

  • Diagnosing and resolving performance bottlenecks
  • Best practices for optimizing data and control flows
  • Leveraging parallelism and batch processing in SSIS

Conclusion and Recommendations

Requirements

  • Foundational knowledge of SQL and relational database principles
  • Proficiency with SQL Server Management Studio (SSMS)

Target Audience

  • Data professionals
  • Software developers
  • Database administrators

Number of participants


Price per participant

Provisional Upcoming Courses (Require 5+ participants)

Related Categories