Get in Touch
 Duration 14 hours

Course Outline

Constructing Data Flows

  • An overview of data flow tasks and transformation components
  • Managing data sources and destinations
  • Applying standard data transformations
  • Resolving data quality challenges

SSIS Control Flow Mechanics

  • Comprehending control flow tasks
  • Utilizing containers to regulate control flow
  • Incorporating loops and conditional logic
  • Directing the overall package execution sequence

Sophisticated Data Transformation Strategies

  • Deploying advanced transformation tools
  • Techniques for data cleansing, validation, and enrichment
  • Methods for aggregation and summarization
  • Detailed implementation of Slowly Changing Dimensions (SCD)

Utilizing Variables and Parameters

  • Fundamentals of variables and parameters
  • Leveraging variables to dictate package behavior
  • Configuring package properties dynamically

Overseeing SSIS Package Execution

  • Setting up package execution options
  • Strategies for error handling and logging
  • Employing event handlers to address runtime events
  • Automating and scheduling execution via SQL Server Agent

Deploying and Administering SSIS Packages

  • Exploring deployment models in SQL Server 2022
  • Installing packages into the SSIS catalog
  • Tracking performance and debugging deployed packages

Performance Tuning and Optimization

  • Detecting and mitigating performance bottlenecks
  • Best practices for refining 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
  • Experience with SQL Server Management Studio (SSMS)

Target Audience

  • Data professionals
  • Developers
  • Database administrators

Number of participants


Price per participant

Upcoming Courses

Related Categories