Get in Touch
 Duration 14 hours

Course Outline

Crafting Data Flows

  • An examination of data flow tasks and transformation components
  • Interacting with various data sources and destinations
  • Applying standard data transformation methods
  • Addressing data quality challenges

Control Flow Mechanics in SSIS

  • Comprehending control flow operations
  • Leveraging containers to orchestrate control flow
  • Integrating loops and conditional decision points
  • Overseeing the overall execution sequence of packages

Sophisticated Transformation Strategies

  • Utilizing higher-level transformation components
  • Performing data cleansing, validation, and enrichment
  • Techniques for data aggregation and summarization
  • A detailed implementation of Slowly Changing Dimensions (SCD)

Utilizing Variables and Parameters

  • Foundations of variables and parameters in SSIS
  • Employing variables to dictate package behavior
  • Dynamically adjusting package properties

Supervising SSIS Package Execution

  • Setting up execution options for packages
  • Strategies for error management and logging
  • Harnessing event handlers for runtime event management
  • Automating schedules via SQL Server Agent

Deployment and Administration of SSIS Packages

  • Exploring deployment models specific to SQL Server 2022
  • Pushing packages to the SSIS catalog
  • Monitoring health and troubleshooting live packages

Performance Tuning and Optimization

  • Spotting and resolving performance bottlenecks
  • Best practices for streamlining data and control flows
  • Leveraging parallelism and batch processing in SSIS

Conclusion and Future Directions

Requirements

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

Intended Audience

  • Data specialists
  • Software developers
  • Database administrators

Number of participants


Price per participant

Upcoming Courses

Related Categories