Get in Touch
 Duration 14 hours

Course Outline

Constructing Data Flows

  • Introduction to data flow tasks and transformation components
  • Managing data sources and output destinations
  • Applying standard data transformation methods
  • Addressing data quality concerns

SSIS Control Flow Mechanics

  • Comprehending control flow tasks
  • Leveraging containers for flow management
  • Integrating loops and conditional logic structures
  • Orchestrating package execution paths

Sophisticated Data Transformation Strategies

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

Leveraging Variables and Parameters

  • Foundations of variables and parameters
  • Using variables to direct package behavior
  • Dynamic adjustment of package properties

Overseeing SSIS Package Execution

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

Deployment and Package Administration

  • Deployment models specific to SQL Server 2022
  • Publishing packages to the SSIS catalog
  • Monitoring and diagnosing deployed packages

Performance Optimization and Tuning

  • Detecting and resolving performance constraints
  • Best practices for enhancing data and control flows
  • Implementing parallelism and batch processing in SSIS

Course Recap and Future Directions

Requirements

  • A foundational grasp 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