Get in Touch
 Duration 14 hours

Course Outline

Designing Data Flows

  • An overview of data flow tasks and transformations
  • Working with various data sources and destinations
  • Implementing standard data transformations
  • Addressing data quality challenges

Control Flow in SSIS

  • Comprehending control flow tasks
  • Utilising containers to orchestrate control flow
  • Incorporating loops and conditional logic
  • Managing the execution flow of packages

Advanced Data Transformation Techniques

  • Applying advanced transformations
  • Data cleansing, validation, and enrichment
  • Aggregation and summarisation methods
  • Detailed implementation of Slowly Changing Dimensions (SCD)

Working with Variables and Parameters

  • An introduction to variables and parameters
  • Using variables to regulate package behaviour
  • Dynamic configuration of package properties

Managing SSIS Package Execution

  • Configuring package execution settings
  • Strategies for error handling and logging
  • Utilising event handlers to manage runtime events
  • Scheduling and automating execution via SQL Server Agent

Deploying and Managing SSIS Packages

  • Deployment models in SQL Server 2022
  • Deploying packages to the SSIS catalog
  • Monitoring and troubleshooting deployed packages

Performance Tuning and Optimisation

  • Identifying and resolving performance bottlenecks
  • Best practices for optimising data and control flows
  • Parallelism and batch processing in SSIS

Summary and Next Steps

Requirements

  • Fundamental knowledge of SQL and relational database concepts
  • Familiarity with SQL Server Management Studio (SSMS)

Audience

  • Data professionals
  • Developers
  • Database administrators

Custom Corporate Training

Training solutions designed exclusively for businesses.

  • Customised 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 £3200 + VAT*

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

Provisional Upcoming Courses (Contact Us For More Information)

Related Categories