Get in Touch
 Duration 14 hours

Course Outline

Designing Data Flows

  • An introduction to data flow tasks and transformation logic
  • Connecting and managing data sources and destinations
  • Applying standard data transformations
  • Mitigating data quality challenges

Control Flow in SSIS

  • Exploring the mechanics of control flow tasks
  • Utilising containers to orchestrate control flow
  • Building loops and conditional decision paths
  • Overseeing the overall package execution sequence

Advanced Data Transformation Techniques

  • Applying high-level transformation tools
  • Data cleansing, validation, and enrichment strategies
  • Methods for aggregation and data summarisation
  • In-depth implementation of Slowly Changing Dimensions (SCD)

Working with Variables and Parameters

  • Core concepts of variables and parameters
  • Leveraging variables to steer package behaviour
  • Dynamically configuring package properties

Managing SSIS Package Execution

  • Setting optimal package execution options
  • Strategies for error handling and logging
  • Utilising event handlers to respond to runtime events
  • Automating and scheduling runs via SQL Server Agent

Deploying and Managing SSIS Packages

  • Understanding deployment models in SQL Server 2022
  • Publishing packages to the SSIS catalog
  • Monitoring health and troubleshooting deployed solutions

Performance Tuning and Optimization

  • Diagnosing and resolving performance bottlenecks
  • Best practices for optimising both data and control flows
  • Implementing parallelism and batch processing within SSIS

Summary and Next Steps

Requirements

  • A foundational grasp of SQL and relational database principles
  • Practical experience with SQL Server Management Studio (SSMS)

Target Audience

  • Data specialists
  • Developers
  • Database administrators

Number of participants


Price per participant

Provisional Upcoming Courses (Require 5+ participants)

Related Categories