Get in Touch
 Duration 14 hours

Course Outline

Data Flow Architecture

  • Foundations of data flow tasks and transformation components
  • Configuring and integrating data sources and destinations
  • Applying standard data transformation methods
  • Strategies for addressing data quality concerns

SSIS Control Flow Management

  • Analyzing the functionality of control flow tasks
  • Utilizing containers to structure and manage control flow
  • Implementing iterative loops and conditional branching logic
  • Oversight of package execution sequences

Advanced Transformation Methods

  • Leveraging sophisticated transformation tools
  • Techniques for data cleansing, validation, and enrichment
  • Methologies for data aggregation and summarization
  • Detailed implementation of Slowly Changing Dimensions (SCD)

Variable and Parameter Management

  • Core concepts of variables and parameters
  • Utilizing variables to dynamically control package behavior
  • Implementing dynamic configuration of package attributes

SSIS Package Execution Control

  • Setting up execution options for optimal performance
  • Defining error handling and logging frameworks
  • Leveraging event handlers to respond to runtime events
  • Automating schedules and execution via SQL Server Agent

Package Deployment and Administration

  • Exploring deployment models specific to SQL Server 2022
  • Processes for publishing packages to the SSIS catalog
  • Techniques for monitoring and resolving issues in deployed packages

Performance Optimization

  • Diagnosing and mitigating performance bottlenecks
  • Best practices for enhancing data and control flow efficiency
  • Implementing parallelism and batch processing strategies in SSIS

Conclusion and Future Learning Paths

Requirements

  • A fundamental grasp of SQL and relational database principles
  • Working knowledge of SQL Server Management Studio (SSMS)

Target Audience

  • Data professionals
  • Software 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.
Investment

Price per private group, online live training, starting from 2900 € + VAT*

Contact us for an exact quote and to hear our latest promotions

Upcoming Courses

Related Categories