Get in Touch
 Duration 14 hours

Course Outline

Designing Data Flows

  • Exploring the landscape of data flow tasks and transformations
  • Integrating various data sources and destinations
  • Applying standard data transformation methods
  • Resolving data quality challenges

Control Flow in SSIS

  • Gaining insight into control flow mechanisms
  • Leveraging containers to orchestrate control flow
  • Integrating loops and conditional branching logic
  • Regulating the overall package execution sequence

Advanced Data Transformation Techniques

  • Utilizing specialized transformation capabilities
  • Performing data cleansing, validation, and enrichment
  • Applying aggregation and summarization methods
  • Detailed implementation of Slowly Changing Dimensions (SCD)

Working with Variables and Parameters

  • Fundamentals of variables and parameters
  • Utilizing variables to modulate package behavior
  • Implementing dynamic configuration for package properties

Managing SSIS Package Execution

  • Setting up package execution preferences
  • Developing error handling and logging strategies
  • Employing event handlers to address runtime occurrences
  • Scheduling and automating execution via SQL Server Agent

Deploying and Managing SSIS Packages

  • Examining deployment models in SQL Server 2022
  • Deploying packages to the SSIS catalog
  • Monitoring and diagnosing deployed packages

Performance Tuning and Optimization

  • Identifying and resolving performance bottlenecks
  • Adopting best practices for optimizing data and control flows
  • Leveraging parallelism and batch processing in SSIS

Summary and Next Steps

Requirements

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

Target Audience

  • Data professionals
  • Software developers
  • Database administrators

Related Categories