Get in Touch
 Duration 14 hours

Course Outline

Designing Data Flows

  • Fundamentals of data flow tasks and transformations.
  • Integration with various data sources and destinations.
  • Application of standard data transformations.
  • Strategies for addressing data quality challenges.

Control Flow in SSIS

  • Core concepts of control flow tasks.
  • Leveraging containers to orchestrate control flow.
  • Implementation of loops and conditional logic.
  • Orchestrating the overall package execution flow.

Advanced Data Transformation Techniques

  • Utilization of complex transformation components.
  • Processes for data cleansing, validation, and enrichment.
  • Methods for aggregation and data summarization.
  • In-depth implementation of Slowly Changing Dimensions (SCD).

Working with Variables and Parameters

  • Overview of variable and parameter usage.
  • Utilizing variables to regulate package behavior.
  • Dynamic configuration of package properties.

Managing SSIS Package Execution

  • Setting package execution preferences.
  • Development of error handling and logging frameworks.
  • Utilization of event handlers for runtime event management.
  • Scheduling and automation via SQL Server Agent.

Deploying and Managing SSIS Packages

  • Deployment strategies specific to SQL Server 2022.
  • Publishing packages to the SSIS catalog.
  • Monitoring and resolving issues in deployed packages.

Performance Tuning and Optimization

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

Summary and Next Steps

Requirements

  • Foundational knowledge of SQL and relational database principles.
  • Proficiency in using SQL Server Management Studio (SSMS).

Target Audience

  • Data professionals.
  • Software developers.
  • Database administrators.

Number of participants


Price per participant

Upcoming Courses

Related Categories