Get in Touch
 Duration 14 hours

Course Outline

Data Flow Architecture

  • Introduction to data flow tasks and transformation mechanisms
  • Integration of various data sources and destinations
  • Application of standard data transformations
  • Strategies for addressing data quality challenges

Control Flow Management in SSIS

  • Analysis of control flow task functionalities
  • Leveraging containers to streamline control flow
  • Implementation of loops and conditional branching
  • Oversight of the package execution sequence

Advanced Transformation Methodologies

  • Application of complex transformation features
  • Techniques for data cleansing, validation, and enrichment
  • Methods for aggregation and data summarization
  • In-depth implementation of Slowly Changing Dimensions (SCD)

Utilization of Variables and Parameters

  • Foundations of variables and parameter usage
  • Controlling package behavior through variables
  • Dynamic adjustment of package properties

Oversight of SSIS Package Execution

  • Configuration of execution parameters
  • Strategies for error handling and logging
  • Management of runtime events via event handlers
  • Automation and scheduling using SQL Server Agent

Deployment and Package Management

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

Performance Optimization

  • Identification and resolution of performance bottlenecks
  • Best practices for optimizing data and control flows
  • Application of parallelism and batch processing in SSIS

Wrap-up and Future Directions

Requirements

  • A fundamental grasp of SQL and relational database principles
  • Working knowledge of SQL Server Management Studio (SSMS)

Target Audience

  • Data professionals
  • Developers
  • Database administrators

Number of participants


Price per participant

Upcoming Courses

Related Categories