Get in Touch
 Duration 14 hours

Course Outline

Designing Data Flows

  • Introduction to data flow tasks and transformation components
  • Connecting and managing data sources and destinations
  • Applying standard data transformation methods
  • Mitigating common data quality challenges

Control Flow in SSIS

  • Exploring the role of control flow tasks
  • Utilizing containers for structured control flow management
  • Integrating loops and conditional logic
  • Orchestrating the overall package execution sequence

Advanced Data Transformation Techniques

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

Working with Variables and Parameters

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

Managing SSIS Package Execution

  • Setting package execution preferences
  • Developing robust error handling and logging strategies
  • Employing event handlers to respond to runtime events
  • Automating schedules and execution via SQL Server Agent

Deploying and Managing SSIS Packages

  • Examining deployment models in SQL Server 2022
  • Publishing packages to the SSIS catalog
  • Overseeing and resolving issues in deployed packages

Performance Tuning and Optimization

  • Detecting and resolving performance bottlenecks
  • Applying best practices for data and control flow optimization
  • Optimizing parallelism and batch processing capabilities

Summary and Next Steps

Requirements

  • Foundational knowledge of SQL and relational database structures
  • Proficiency with SQL Server Management Studio (SSMS)

Target Audience

  • Data specialists
  • Software developers
  • Database administrators

Number of participants


Price per participant (excl. VAT)

Upcoming Courses

Related Categories