Get in Touch
 Duration 14 hours

Course Outline

Designing Data Flows

  • An overview of data flow tasks and associated transformations
  • Managing data sources and destinations
  • Applying standard data transformation methods
  • Strategies for addressing data quality concerns

Control Flow in SSIS

  • Comprehending control flow tasks
  • Utilizing containers to organize control flow
  • Incorporating loops and conditional logic
  • Oversight of package execution sequences

Advanced Data Transformation Techniques

  • Leveraging advanced transformation tools
  • Data cleansing, validation, and enrichment processes
  • 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
  • Dynamically configuring package properties

Managing SSIS Package Execution

  • Setting up package execution configurations
  • Implementing error handling and logging strategies
  • Using event handlers to manage runtime occurrences
  • Automating scheduling via SQL Server Agent

Deploying and Managing SSIS Packages

  • Exploration of deployment models in SQL Server 2022
  • Deploying packages to the SSIS catalog
  • Monitoring and resolving issues in deployed packages

Performance Tuning and Optimization

  • Diagnosing and resolving performance bottlenecks
  • Best practices for optimizing data and control flows
  • Implementing parallelism and batch processing in SSIS

Summary and Next Steps

Requirements

  • A foundational understanding of SQL and relational database concepts
  • Proficiency in using SQL Server Management Studio (SSMS)

Target Audience

  • Data professionals
  • Developers
  • Database administrators

Number of participants


Price per participant

Upcoming Courses

Related Categories