Get in Touch
 Duration 14 hours

Course Outline

Designing Data Flows

  • Overview of data flow tasks and transformations
  • Integration of data sources and destinations
  • Application of common data transformations
  • Strategies for handling data quality issues

Control Flow in SSIS

  • Understanding control flow tasks
  • Utilizing containers to manage control flow
  • Implementation of loops and conditional logic
  • Managing package execution flow

Advanced Data Transformation Techniques

  • Application of advanced transformations
  • Data cleansing, validation, and enrichment
  • Aggregation and summarization techniques
  • Detailed implementation of Slowly Changing Dimensions (SCD)

Working with Variables and Parameters

  • Introduction to variables and parameters
  • Using variables to control package behavior
  • Dynamic configuration of package properties

Managing SSIS Package Execution

  • Configuring package execution options
  • Error handling and logging strategies
  • Using event handlers to manage runtime events
  • Scheduling and automating execution with SQL Server Agent

Deploying and Managing SSIS Packages

  • Deployment models in SQL Server 2022
  • Deploying packages to the SSIS catalog
  • Monitoring and troubleshooting deployed packages

Performance Tuning and Optimization

  • Identifying and addressing performance bottlenecks
  • Best practices for optimizing data flows and control flows
  • Parallelism and batch processing in SSIS

Summary and Next Steps

Requirements

  • Fundamental knowledge of SQL and relational database concepts
  • Proficiency with SQL Server Management Studio (SSMS)

Target Audience

  • Data professionals
  • Developers
  • Database administrators

Number of participants


Price per participant

Upcoming Courses

Related Categories