Get in Touch
 Duration 14 hours

Course Outline

Designing Data Flows

  • Overview of data flow tasks and transformation options
  • Configuring data sources and destinations
  • Applying standard data transformation methods
  • Addressing data quality challenges

Control Flow in SSIS

  • Understanding the role of control flow tasks
  • Utilizing containers to structure control flow
  • Building loops and conditional logic structures
  • Managing the overall package execution sequence

Advanced Data Transformation Techniques

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

Working with Variables and Parameters

  • Introduction to the use of variables and parameters
  • Leveraging variables to dictate package behavior
  • Dynamically configuring package properties

Managing SSIS Package Execution

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

Deploying and Managing SSIS Packages

  • Exploring deployment models in SQL Server 2022
  • Deploying packages into the SSIS catalog
  • Monitoring and resolving issues with deployed packages

Performance Tuning and Optimization

  • Identifying and resolving performance bottlenecks
  • Best practices for optimizing both data and control flows
  • Leveraging parallelism and batch processing in SSIS

Summary and Next Steps

Requirements

  • A foundational understanding of SQL and relational database principles
  • Familiarity with the SQL Server Management Studio (SSMS) interface

Target Audience

  • Data professionals
  • Software developers
  • Database administrators

Number of participants


Price per participant

Upcoming Courses

Related Categories