Get in Touch
 Duration 14 hours

Course Outline

Designing Data Flows

  • Introduction to data flow tasks and transformation logic
  • Connecting with diverse data sources and destinations
  • Applying standard data transformations
  • Addressing data quality challenges

Control Flow in SSIS

  • Comprehending control flow tasks
  • Leveraging containers to orchestrate control flow
  • Constructing loops and conditional logic structures
  • Oversight of package execution sequences

Advanced Data Transformation Techniques

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

Working with Variables and Parameters

  • Foundations of variables and parameters
  • Employing variables to regulate package behavior
  • Dynamic adjustment of package properties

Managing SSIS Package Execution

  • Setting execution configurations
  • Strategies for error handling and logging
  • Managing runtime events via event handlers
  • Automating and scheduling execution through SQL Server Agent

Deploying and Managing SSIS Packages

  • Deployment frameworks in SQL Server 2022
  • Installing packages into the SSIS catalog
  • Monitoring and diagnosing deployed packages

Performance Tuning and Optimization

  • Detecting and resolving performance constraints
  • Optimization best practices for data and control flows
  • Leveraging parallelism and batch processing in SSIS

Summary and Next Steps

Requirements

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

Target Audience

  • Data specialists
  • Software developers
  • Database administrators

Related Categories