Get in Touch
 Duration 14 hours

Course Outline

Designing Data Flows

  • Overview of data flow tasks and transformations.
  • Integration with data sources and destinations.
  • Implementation of standard data transformations.
  • Strategies for addressing data quality issues.

Control Flow in SSIS

  • Comprehension of control flow tasks.
  • Utilizing containers to orchestrate control flow.
  • Implementation of loops and conditional logic.
  • Management of package execution flow.

Advanced Data Transformation Techniques

  • Application of advanced transformations.
  • Data cleansing, validation, and enrichment processes.
  • Methods for aggregation and summarization.
  • In-depth implementation of Slowly Changing Dimensions (SCD).

Working with Variables and Parameters

  • Introduction to variables and parameters.
  • Using variables to regulate package behaviour.
  • Dynamic configuration of package properties.

Managing SSIS Package Execution

  • Configuration of package execution options.
  • Strategies for error handling and logging.
  • Utilizing event handlers to manage runtime events.
  • Scheduling and automating execution via SQL Server Agent.

Deploying and Managing SSIS Packages

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

Performance Tuning and Optimization

  • Identification and resolution of performance bottlenecks.
  • Best practices for optimizing data and control flows.
  • Implementation of parallelism and batch processing in SSIS.

Summary and Next Steps

Requirements

  • A foundational understanding of SQL and relational database concepts.
  • Familiarity with SQL Server Management Studio (SSMS).

Target Audience

  • Data professionals
  • Developers
  • Database administrators

Upcoming Courses

Related Categories