Get in Touch
 Duration 14 hours

Course Outline

Constructing Data Flows

  • An overview of data flow tasks and their associated transformations.
  • Integration of various data sources and output destinations.
  • Application of standard data transformation techniques.
  • Strategies for addressing data quality concerns.

Managing Control Flow in SSIS

  • In-depth understanding of control flow tasks.
  • Utilizing containers to orchestrate control flow logic.
  • Implementation of loops and conditional branching.
  • Supervising the overall execution flow of the package.

Sophisticated Data Transformation Methods

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

Utilizing Variables and Parameters

  • Fundamentals of SSIS variables and parameters.
  • Employing variables to modulate package behavior dynamically.
  • Configuring package properties for dynamic adjustments.

Supervising SSIS Package Execution

  • Setting up execution options for optimal performance.
  • Implementing comprehensive error handling and logging protocols.
  • Managing runtime events through event handlers.
  • Scheduling and automating package runs via SQL Server Agent.

Deployment and Package Administration

  • Exploring deployment models specific to SQL Server 2022.
  • Publishing packages to the SSIS catalog.
  • Monitoring health and troubleshooting deployed solutions.

Performance Enhancement and Optimization

  • Identifying and resolving performance bottlenecks.
  • Applying best practices to streamline data and control flows.
  • Leveraging parallelism and batch processing within SSIS.

Wrap-up and Future Steps

Requirements

  • A fundamental grasp of SQL syntax and relational database principles.
  • Working 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