Get in Touch
 Duration 14 hours

Course Outline

Designing Data Flows

  • Overview of data flow tasks and transformation capabilities
  • Managing connections to various data sources and destinations
  • Applying standard data transformation techniques
  • Addressing common data quality challenges

Control Flow in SSIS

  • Exploring the mechanics of control flow tasks
  • Utilizing containers to orchestrate workflow logic
  • Incorporating loops and conditional branching
  • Regulating the overall package execution sequence

Advanced Data Transformation Techniques

  • Leveraging sophisticated transformation tools
  • Performing data cleansing, validation, and enrichment
  • Employing methods for aggregation and data summarization
  • Detailed implementation of Slowly Changing Dimensions (SCD)

Utilizing Variables and Parameters

  • Fundamentals of variables and parameters in SSIS
  • Using variables to dynamically control package behavior
  • Dynamic configuration of package properties

Managing SSIS Package Execution

  • Configuring execution options for optimal performance
  • Strategies for error handling and comprehensive logging
  • Leveraging event handlers to respond to runtime occurrences
  • Scheduling and automating workflows via SQL Server Agent

Deploying and Managing SSIS Packages

  • Exploring deployment models specific to SQL Server 2022
  • Deploying packages into the SSIS catalog
  • Monitoring performance and troubleshooting deployed solutions

Performance Tuning and Optimization

  • Identifying and resolving performance bottlenecks
  • Best practices for streamlining data and control flows
  • Optimizing parallelism and batch processing within SSIS

Summary and Next Steps

Requirements

  • A foundational grasp of SQL and relational database principles
  • Basic familiarity with SQL Server Management Studio (SSMS)

Target Audience

  • Data specialists
  • Software developers
  • Database administrators

Number of participants


Price per participant

Upcoming Courses

Related Categories