Get in Touch
 Duration 14 hours

Course Outline

Designing Data Flows

  • Introduction to data flow tasks and transformation components
  • Integrating various data sources and destinations
  • Executing standard data transformation processes
  • Mitigating data quality issues

Control Flow in SSIS

  • Exploring control flow tasks
  • Leveraging containers to structure control flow
  • Developing loops and conditional logic structures
  • Orchestrating the overall package execution sequence

Advanced Data Transformation Techniques

  • Applying complex transformation methods
  • Performing data cleansing, validation, and enrichment
  • Techniques for aggregation and data summarization
  • Detailed implementation of Slowly Changing Dimensions (SCD)

Working with Variables and Parameters

  • Overview of variables and parameter usage
  • Utilizing variables to regulate package behavior
  • Implementing dynamic configuration for package properties

Managing SSIS Package Execution

  • Setting up package execution configurations
  • Strategies for error handling and logging
  • Employing event handlers for runtime event management
  • Scheduling and automating tasks via SQL Server Agent

Deploying and Managing SSIS Packages

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

Performance Tuning and Optimization

  • Diagnosing and resolving performance bottlenecks
  • Best practices for enhancing data and control flow efficiency
  • Managing parallelism and batch processing within SSIS

Summary and Next Steps

Requirements

  • Fundamental understanding of SQL and relational database principles
  • Proficiency with SQL Server Management Studio (SSMS)

Target Audience

  • Data professionals
  • Software developers
  • Database administrators

Number of participants


Price per participant

Upcoming Courses

Related Categories